VBA Project Protection 1

[Firery]

I have created an Excel spreadsheet with VB locked from viewing.
A friend has shown me a program called "Advanced VBA Password Recovery" which was able to change the password for the VB Project without even opening the file, thus allowing someone to open the file and then view my VB code with the new password.

Is there any way to prevent this?
Write Protecting the file will stop it, but they can disable the write protect in the file properties anyway.

 

[JerryKlmns]

There is no electronic lock that can´t be unlocked! For the rest, just wait till tomorrow!

 

[abaldwin]

Perfect lien JerryKlmns,

"There is no electronic lock that can´t be unlocked! For the rest, just wait till tomorrow!"

Where did you get that from.

I totally agree. No lock for that matter can not be unlocked somehow.

The problem you are running into here is the limitation of VBA in one of the MS apps compared to VB itself or some other true programming language.

VBA is compiled at run-time and hence for $30 you can buy a Password Recovery tool that any fool can google for and be into the code in a matter of 5 minutes.

If you are truely concerened abou the "security" or privacy of your code then your best option is to write the code in VB, C, .Net, etc etc etc then compile and distribute the application.



Andy Baldwin

"Testing is the most overlooked programming language on the books!