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.



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

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 Peterson wrote:

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

--

Dave Peterson

Dave Peterson wrote in
:

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 Peterson wrote:

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


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

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



Steve J wrote:

<<snipped


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

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

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?