For Vba developers using Excel, Word, AutoCAD...
Remove VBA project password
This is a useful tip to take into account. For example, an old Excel VBA project happens to have launched an unexpected error, and the project file was password protected when it was installed ages ago. Your customer doesn’t know the password. Perhaps the developer left the company and he was the only one who knew it. Of course that’s not an ideal situation, but you know these things do happen. So, what are we going to do now?. There is a ‘trick’, or a workaround –if you prefer- to deal with this issue. Here’s the tip. You will need to get an Hexadecimal editor. Some freeware ones are easy to find. This example will be using the HxD editor.
Just open the VBA project file with HxD. Find the string “DPB”.
Change it to “DPx” and Save the project file.
Open the project file with Excel.
Excel will show warnings, but just click OK until it’s open.
Now press ALT + F11, and go change the project’s password without removing it.
Note the new password.
Save, Close and Open back.
Press ALT + F11 again and go enter the new password.
Now you can go to the project Properties and remove the password.
Save.
You’re done.
Just open the VBA project file with HxD. Find the string “DPB”.
Change it to “DPx” and Save the project file.
Open the project file with Excel.
Excel will show warnings, but just click OK until it’s open.
Now press ALT + F11, and go change the project’s password without removing it.
Note the new password.
Save, Close and Open back.
Press ALT + F11 again and go enter the new password.
Now you can go to the project Properties and remove the password.
Save.
You’re done.
Source http://vbaforum.blogspot.com
Reviews:
Post a Comment