password protect vba code

J

JulieD

Hi

right mouse click on your workbook name in the VBE window .. choose
VBAProjectProperties, and choose the Protection tab - you can set the
password in there.

But remember - passwords only keep honest people out :)

Cheers
JulieD
 
J

Jack Sheet

Umm yes and no

From the menu bar in the Visual Basic Editor:
Tools/VBAProject Properties/Protection Tab

BUT:
Very easy to crack the password.

Only secure way around that is using compiled add-ins, I believe, but that
is outside of my experience.
 
Top