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!