Cracking excel VBA password

To remove VBA password in Excel document use following steps. The steps are really simple and you can remove the password in no time.Backup the xls file first!

1. Using a HEX editor, locate the DPB=... part


2. Change the DPB=... string to DPx=...


3. Open the xls file in Excel


4. Excel discovers an invalid key (DPx) and asks whether you want to continue loading the project (basically ignoring the protection)


5. Open the VBA editor (ALT+F11)


6. Overwrite the password, so change it to something you can remember


7. Save the xls file


8. Close and reopen the document and work your VBA magic!

Solution was found at: http://stackoverflow.com/questions/1026483/is-there-a-way-to-crack-the-password-on-an-excel-vba-project

If you want to remove password from protected sheet then see https://nirmaljoshi.wordpress.com/2011/05/25/breaking-excel-passoword/.