PDA

View Full Version : Solved: Hiding Code



zoom38
04-18-2006, 07:15 AM
Is there a way to hide vba code or block access to the code viewer?

Thanks
Gary

Jacob Hilderbrand
04-18-2006, 07:37 AM
Open the VBE and go to Tools | VBAProject Properties...
Click the Protection tab.
Check the box for Lock project for viewing.
Add a password.

zoom38
04-18-2006, 07:50 AM
Thanks for the quick response DRJ. I did as you suggested but it doesn't seem to work. I can still get into and modify the vba code and it doesn't ask me to supply the password that I set.

zoom38
04-18-2006, 07:54 AM
Disreguard my last message. After I closed the file and reopened it then attempted to get into the vba code it asked for the password.
Thanks DRJ
Please mark it solved.

lucas
04-18-2006, 10:54 AM
You should know that this is not a fool-proof way to protect your code but it will keep out most average users....

thread marked solved

Jacob Hilderbrand
04-18-2006, 11:46 AM
Yea, you have to save and close for it to take effect.

Glad to help :beerchug:

Take Care