Some days ago I had to improve a VBA macro but password was lost, so there was no direct way to enter code in VBE. There are a lot of tricks I found in the WWW, some of them even provide a tool. But do you trust such tools?
Beside that I found a such an easy to use instruction, »hidden« in a blog comment, I must share with you.
- Open the zipped folder and navigate into the
- Extract the
vbaProject.binfile and open it in a Hex Editor
- Search for
DPBand replace with
- Replace the old
vbaProject.binfile with this new one in the zip folder (and re-zip)
- Change the file extension back to
- Open workbook and ignore all warning messages
- Export the code modules and then re-add them (delete the old ones before)
Thanks to Gordo for this comment!
4 replies on “Remove VBA Password from Excel 2007/2010 file”
1. The title contains the german word “vom” instead of “from a”.
2. On the last line, it is “comment”, not “commend”.
this method doesn’t work by me. I get the alert that the system delete vbaProject.bin from the workbook, because of a failure. What can be the reason.
Oh… I have never had such a problem. I needed this solution only once and it worked for me. Which Office version do you use? I used Office 2013.
Alternatively, you can sedn me your file and I can have a look at?