Solved: How to password protect the VBA Code

[kbsudhir]

Please let me know how ro password protect the VBA code I have written so that nobody can view the code.

[grichey]

in editor
tools>vba project properties
Check Lock Project from viewing
Enter password

finite

[kbsudhir]

Thank you very much.:thumb

[Brandtrock]

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]

... 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]

hahaha -- that's hilarious. I would hope no one is using the alt+11 for making $ecret c0de

[kbsudhir]

Thanks guys I will keep that in mind