Password protect macros in Excel
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.
Greg Sottile wrote:
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
|