PDA

View Full Version : Solved: How to password protect the VBA Code



kbsudhir
10-31-2007, 02:17 PM
Please let me know how ro password protect the VBA code I have written so that nobody can view the code.

grichey
10-31-2007, 02:42 PM
in editor
tools>vba project properties
Check Lock Project from viewing
Enter password

finite

kbsudhir
10-31-2007, 02:55 PM
Thank you very much.:thumb

Brandtrock
11-01-2007, 02:45 AM
grichey is correct insofar as those instructions will get you to where you need to protect your VBA project which will keep most pesky (nosey) individuals from messing with your code, but the VBA password is broken easily enough by those who are more determined (or anyone with $20 and internet access).

Office is not a secure development environment.

Regards,

TonyJollans
11-01-2007, 05:44 AM
... the VBA password is broken easily enough by those who are more determined (or anyone with $20 and internet access)

Could I really charge $20 a time for such a service?? :devil2:


kbsudhir,

I'm just really reiterating this:

Office is not a secure development environment.

grichey
11-01-2007, 07:28 AM
hahaha -- that's hilarious. I would hope no one is using the alt+11 for making $ecret c0de

kbsudhir
11-01-2007, 11:23 AM
Thanks guys I will keep that in mind