Password protect macros in Excel

  • Thread starter Thread starter Greg Sottile
  • Start date Start date
G

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?
 
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.
 
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!
 
When all is said and done, it will take a knowledgeable person about 5
minutes to discover your "hidden" password.
 
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!

Dave said:
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.
Click to expand...

Its also worth pointing out that if you protect your code on say XL2003
you wont be able to unprotect it in XL97.
Click to expand...
 
I think the change in protection (encryption algorithms???) started with
xl2k--not just xl2003.
 
Back
Top