password protect vba code

  • Thread starter Thread starter greg
  • Start date Start date
G

greg

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top