Password protect macros in Excel

[Greg Sottile]

I havea password protected workbook. I wrote some code to automate some
tasks and have embedded the password in the code to unprotect where
necessary. Code works fine. Question is how to protect the code to protect
password from bein discovered?

 

[Dave Peterson]

Inside the VBE:
Select the project associated with your workbook
Tools|VBAProject Properties
Protection tab.

But this (like any password) can be broken pretty easily by anyone with enough
cash to buy a password breaker or anyone who can search the web for the right
combination of keywords.

 

[Dave Peterson]

ps. After you supply a password (and lock the project from viewing), save the
workbook, close the workbook, and then open the VBE to see if you can view the
project.

pps. Remember your password. You don't want to be one of those people who have
to purchase a password breaker or search the web!

 

[Bob I]

When all is said and done, it will take a knowledgeable person about 5
minutes to discover your "hidden" password.

 

[Steve J]

ps. After you supply a password (and lock the project from viewing),
save the workbook, close the workbook, and then open the VBE to see if
you can view the project.

pps. Remember your password. You don't want to be one of those
people who have to purchase a password breaker or search the web!

Inside the VBE:
Select the project associated with your workbook
Tools|VBAProject Properties
Protection tab.

But this (like any password) can be broken pretty easily by anyone
with enough cash to buy a password breaker or anyone who can search
the web for the right combination of keywords.

Its also worth pointing out that if you protect your code on say XL2003
you wont be able to unprotect it in XL97.

 

[Dave Peterson]

I think the change in protection (encryption algorithms???) started with
xl2k--not just xl2003.