Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Scottflyer

    password protecting macros

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

    How To Protect VBA Project with code?????

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

    VBAProject Protection with Code, How to??????

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

    Protect-Unprotect VBAProject Programatically

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

Part and Inventory Search

Back
Top