Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Removing the mot de passe depuis a VBA project

ayi

How can I programmatically remove a (known) password from an Excel VBA project?
To be clear: I want to remove the password from the VBA Project, not the workbook or any worksheets.
<hr>
Source : [Stack Overflow](<a href="http://www.hexedit.com/" rel="noopener nofollow ugc">http://www.hexedit.com/</a>](<a href="http://www.hexedit.com/" rel="noopener nofollow ugc">http://www.hexedit.com/</a>)

ayi_2

Another way to remove VBA project password is;
<ul>
<li>
Open xls file with a hex editor. 
(ie. Hex Edit <a href="http://www.hexedit.com/">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>
UPDATE: For Excel 2010 (Works for MS Office Pro Plus 2010 [14.0.6023.1000 64bit]),
<ul>
<li>Open the XLSX file with 7zip</li>
</ul>
If workbook is protected:
<ul>
<li>
Browse the folder <code>xl</code>
</li>
<li>
If the workbook is protected, right click <code>workbook.xml</code> and select Edit
</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 Yes.
</li>
<li>
Close 7zip and re-open your XLSX.
</li>
<li>
Click Protect Workbook on Review tab.
</li>
<li>
Optional: Save your file.
</li>
</ul>
If worksheets are protected:
<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 Edit.
</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 Yes.
</li>
<li>
Close 7zip and re-open your XLSX.
</li>
<li>
Click Unprotect Sheet on Review tab.
</li>
<li>
Optional: Save your file.
</li>
</ul>