password protect vba code
 

is it possible to password protect vba code?
if so how can it be done?

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

"greg" wrote in message
...
is it possible to password protect vba code?
if so how can it be done?

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.


"greg" wrote in message
...
is it possible to password protect vba code?
if so how can it be done?

"greg" wrote in message
...
is it possible to password protect vba code?
if so how can it be done?