Alt - F11
Name Project
Click Protection Tab
Enter Password
Also, be certain to check the checkbox "Lock Project for Viewing.
I suggest using a long password, they're harder to crack. Put it in a file so that you won't lose it. I believe that 256 characters is the limit. Put it in...
Hi:
In VBA in Excel, does anyone know how to protect/unprotect the VBA project (not workbooks or worksheets) from within a code segment in a project? I want to modify a protected project using the .Remove and .Import methods but need to uprotect the modules before removing the old ones and...
Hi:
I'm NOT interested in Worksheet or Workbook protection/unprotection as I know how to do that well. I'm interested in unprotecting and protecting the locked VBA Project itself that has been password protected from viewing. I want to update code in existing copies of the project using the...
Hi:
I want to protect and unprotect -- with password from a VBA subroutine or function. I'm currently using the following code, but it only works if the VBA Project is open or unprotected, which doesn't serve my purpose:
Set VBP = ActiveWorkbook.VBProject
If...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.