Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Next
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
Twitch
YouTube
Facebook (EN Publishing)
Facebook (EN World)
Twitter
Instagram
TikTok
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="dunstvangeet" data-source="post: 8416639" data-attributes="member: 6800196"><p>Here's the way to get rid of the password on the sheets. This will work for a lot of Excel workbooks as well. First off, make a backup copy of it, because you'll actually be messing around in the XML sheets for the password file. If you do this badly, it can cause the XLSX book to become unusable. You'll also need a tool like 7zip, which will open up the XLSX file as basically a ZIP file.</p><p></p><p>So, within the XLSX file, it's basically a compressed file of a bunch of XML files. So, now open up the XLSX file with 7Zip, and you'll see that the XLSX file is basically a compressed file of a bunch of sheets.</p><p></p><p>Now under the "xl" folder, you'll find a bunch of XML files. You'll want to do two things here. First is edit open up the "workbook.xml" file. From that, you'll see this XML code somewhere in it: <sheet name="Tables" sheetId="5" <strong>state="veryHidden"</strong> r:id="rId5"/></p><p></p><p>If delete the bold part (I bolded it for you) of that code, you'll reveal the hidden "Tables" sheet when you open it up next time. This is where all the underlying data is stored that makes it run.</p><p></p><p>Now, the next part is getting rid of the password on the sheet protection. This again involves manipulating the XML on the sheets.</p><p></p><p>Under the "worksheets" folder, you'll notice that there are sheets 1-13. The sheets are as follows:</p><p>sheet1 - Start</p><p>sheet2 - Spellcasting</p><p>sheet3 - Custom</p><p>sheet4 - DesignSpace</p><p>sheet5 - Tables</p><p>sheet6 - Character Sheet I</p><p>sheet7 - Character Sheet II</p><p>sheet8 - Character Sheet III</p><p>sheet9 - Character Sheet IV</p><p>sheet10 - Character Sheet V</p><p>sheet11 - Wild Shape</p><p>sheet12 - Character Summary</p><p>sheet13 - Adventurer's Log</p><p></p><p>Some of these sheets have passwords protecting the sheet protection, some of them do not. To get rid of the password, you'll going to look for this following XML tag: <sheetProtection <strong>algorithmName="SHA-512" hashValue="aq9aE+xhWQllX2LYxYBZHx4RMwHIG2ipsSovd1/OM2j4L1AE4QLWc1SipA/0lWRRomH0Zp2ey7/Pgh8B6X186g==" saltValue="JpgWLpvMYlUFpSXWs9vhDw==" spinCount="100000"</strong> sheet="1" objects="1" scenarios="1" selectLockedCells="1" sort="0"/></p><p></p><p>Again, I bolded the part you need to delete from that tag. If you delete this part, that will remove the password from the sheetprotection (but keep the sheetprotection in there). Then you can go in and remove the sheetProtection, as there is no longer a password on it.</p><p></p><p>I don't know about the password to the VBA.</p></blockquote><p></p>
[QUOTE="dunstvangeet, post: 8416639, member: 6800196"] Here's the way to get rid of the password on the sheets. This will work for a lot of Excel workbooks as well. First off, make a backup copy of it, because you'll actually be messing around in the XML sheets for the password file. If you do this badly, it can cause the XLSX book to become unusable. You'll also need a tool like 7zip, which will open up the XLSX file as basically a ZIP file. So, within the XLSX file, it's basically a compressed file of a bunch of XML files. So, now open up the XLSX file with 7Zip, and you'll see that the XLSX file is basically a compressed file of a bunch of sheets. Now under the "xl" folder, you'll find a bunch of XML files. You'll want to do two things here. First is edit open up the "workbook.xml" file. From that, you'll see this XML code somewhere in it: <sheet name="Tables" sheetId="5" [B]state="veryHidden"[/B] r:id="rId5"/> If delete the bold part (I bolded it for you) of that code, you'll reveal the hidden "Tables" sheet when you open it up next time. This is where all the underlying data is stored that makes it run. Now, the next part is getting rid of the password on the sheet protection. This again involves manipulating the XML on the sheets. Under the "worksheets" folder, you'll notice that there are sheets 1-13. The sheets are as follows: sheet1 - Start sheet2 - Spellcasting sheet3 - Custom sheet4 - DesignSpace sheet5 - Tables sheet6 - Character Sheet I sheet7 - Character Sheet II sheet8 - Character Sheet III sheet9 - Character Sheet IV sheet10 - Character Sheet V sheet11 - Wild Shape sheet12 - Character Summary sheet13 - Adventurer's Log Some of these sheets have passwords protecting the sheet protection, some of them do not. To get rid of the password, you'll going to look for this following XML tag: <sheetProtection [B]algorithmName="SHA-512" hashValue="aq9aE+xhWQllX2LYxYBZHx4RMwHIG2ipsSovd1/OM2j4L1AE4QLWc1SipA/0lWRRomH0Zp2ey7/Pgh8B6X186g==" saltValue="JpgWLpvMYlUFpSXWs9vhDw==" spinCount="100000"[/B] sheet="1" objects="1" scenarios="1" selectLockedCells="1" sort="0"/> Again, I bolded the part you need to delete from that tag. If you delete this part, that will remove the password from the sheetprotection (but keep the sheetprotection in there). Then you can go in and remove the sheetProtection, as there is no longer a password on it. I don't know about the password to the VBA. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
Top