I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation… no-one knows the passwords.
Is there a way of removing or cracking the password on a VBA project?
excelpasswordsvba
I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation… no-one knows the passwords.
Is there a way of removing or cracking the password on a VBA project?
Best Answer
You can try this direct
VBA
approach which doesn't require HEX editing. It will work for any files (*.xls, *.xlsm, *.xlam ...).Tested and works on:
Looking for 64 bit version? See this answer
How it works
I will try my best to explain how it works - please excuse my English.
Using the code
Please backup your files first!
Create a new xlsm file and store this code in Module1
code credited to Siwtom (nick name), a Vietnamese developer
Paste this code under the above code in Module1 and run it
Come back to your VBA Projects and enjoy.