password protect VBA code

  • Thread starter Thread starter Horatio J. Bilge
  • Start date Start date
H

Horatio J. Bilge

How can I protect VBA code with a password, so users are unable to view the
code?

Thanks,
~ Horatio
 
Hi Horatio,

In the VBE, with the project selected:

Tools | XYZ Properties | Protection Tab | Password

where XYZ is the project name, the default being VBAProject.
 
Horatio,

In the VBE, Tools - VBA Project properties - Protection tab. Check "Lock
project for viewing."
 
That's what I had been trying, but this time it worked. I guess I did
something different.
Thanks for the help.

~ Horatio
 
You must log in or register to reply here.

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

Similar Threads

Forgot Password 2
Remove Protected Macro Code from Excel Module 4
Using one file to make changes in another file 4
EnableSelection Protecting sheet question 3
Excel Protection 2
Word VBA for deleting Selected Row 0
Enable code in a password protected worksheet 3
Password protect macros in Excel 5

Back
Top