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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
All Courses

From novice to tech pro — start learning today.