Macro Protection

[Vie]

Hi, I want to protect my macros so noone can change them. I have tried using
the VBA Editor, Tools menu, VBA Project Properties, then the Protection tab
and enter a password, but this doesn't work.

Any ideas, I'm using 2007.

Many thanks in advance

V

 

[Dave Peterson]

save and close your workbook.

Then reopen and test it.

 

[Vie]

Thank you. Should have tried that, sorry.

V

save and close your workbook.

Then reopen and test it.

 

[Chip Pearson]

While the built-in protection for a VBA project works, it is very
weak. There are any number of password crackers available on the
Internet that can break the password. I use VBAKey from Passware that
will break the password in a matter of seconds. VBA's security is not
adequate for protecting proprietary data or code with intellectual
property value. For that level of protection, you should create a COM
add-in with VB6 or VBNET or C#. With a COM add-in, only the compiled
code is distributed to the user --- source code is never distributed.,

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)