Can I prevent people from accessing VBE in Excel?

Can I make the VBE access password protected in Excel? Whether is through macro or Alt+F11?  
fitalianoAsked:
Who is Participating?
 
Subnet_ThisConnect With a Mentor Systems AdministratorCommented:
To protect your code, do the following:

Open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it. After doing this you must save, close & reopen the Workbook for the protection to take effect.
0
 
kaosyetiCommented:
subnet this is correct.  also, while your vbe is protected this way, the properties box in the developer tab cannot be viewed, even while the worksheet is unprotected.  also, if there is an issue with your code that activates the debugger, it cannot be used until the password is entered in the vb editor.
0
 
Patrick MatthewsCommented:
Do be aware, though, that this password is not secure.  There are numerous free/cheap utilities available via quick Google search that will shred the password in a few seconds.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.