locking VBA for viewing

[madchemist]

How can I lock the VBA Project from viewing using code?

I would prefer to have it automatically enabled when I open the workbook....

Thanks!

 

[Datsmart]

Setup protection in the VBE (visual basic editor).
In VBE, click "Tools" | "VBA Project Properties... "
Click the Protection Tab
Check the "Lock Project for Viewing" checkbox
Enter and confirm your password.
Next time you open the saved workbook, the properties will take effect.