StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Another way to remove VBA project password is;</p> <ul> <li>Open xls file with a hex editor. (ie. Hex Edit <a href="http://www.hexedit.com/" rel="noreferrer">http://www.hexedit.com/</a>)</li> <li>Search for DPB</li> <li>Replace DPB to DPx</li> <li>Save file.</li> <li>Open file in Excel.</li> <li>Click "Yes" if you get any message box.</li> <li>Set new password from VBA Project Properties. </li> <li>Close and open again file, then type your new password to unprotect.</li> </ul> <p><strong>UPDATE:</strong> For Excel 2010 (Works for MS Office Pro Plus 2010 [14.0.6023.1000 64bit]), </p> <ul> <li>Open the XLSX file with 7zip</li> </ul> <p><strong>If workbook is protected:</strong></p> <ul> <li>Browse the folder <code>xl</code></li> <li>If the workbook is protected, right click <code>workbook.xml</code> and select <strong>Edit</strong></li> <li>Find the portion <code><workbookProtection workbookPassword="XXXX" lockStructure="1"/></code> (<code>XXXX</code> is your encrypted password)</li> <li>Remove <code>XXXX</code> part. (ie. <code><workbookProtection workbookPassword="" lockStructure="1"/></code>)</li> <li>Save the file. </li> <li>When 7zip asks you to update the archive, say <strong>Yes</strong>.</li> <li>Close 7zip and re-open your XLSX.</li> <li>Click <strong>Protect Workbook</strong> on <strong>Review</strong> tab.</li> <li>Optional: Save your file.</li> </ul> <p><strong>If worksheets are protected:</strong></p> <ul> <li>Browse to <code>xl/worksheets/</code> folder.</li> <li>Right click the <code>Sheet1.xml</code>, <code>sheet2.xml</code>, etc and select <strong>Edit</strong>.</li> <li>Find the portion <code><sheetProtection password="XXXX" sheet="1" objects="1" scenarios="1" /></code></li> <li>Remove the encrypted password (ie. <code><sheetProtection password="" sheet="1" objects="1" scenarios="1" /></code>)</li> <li>Save the file. </li> <li>When 7zip asks you to update the archive, say <strong>Yes</strong>.</li> <li>Close 7zip and re-open your XLSX.</li> <li>Click <strong>Unprotect Sheet</strong> on <strong>Review</strong> tab.</li> <li>Optional: Save your file.</li> </ul>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload