Solved: Hiding Code

[zoom38]

Is there a way to hide vba code or block access to the code viewer?

Thanks
Gary

[Jacob Hilderbrand]

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]

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]

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]

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]

Yea, you have to save and close for it to take effect.

Glad to help

Take Care