Hide and Lock PW Protect Code Modules

[sachavez]

Excel 2007

Is there an easy way to keep my code hidden and password protected?

Thanks

 

[VoG]

In the VBE, Tools > VBA Project Properties > Protection tab > check Lock Project for Viewing and enter a password. Save, close and re-open the workbook to see the effect.

N.B. such passwords are crackable.

 

[sachavez]

VoG,

Bingo. I tried your fix earlier but didn't save and exit the file.

Thanks for the tip; it worked like a champ.