Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hola,
I have a workbook in which I protected the VBA code with a password. It works fine. The user doesn't have access to the code. I'm automatically setting the Solver referece using the following code (partly shown). Set oWB = ActiveWorkbook strSolverPath = Application.LibraryPath & "\SOLVER\SOLVER.XLAM" With AddIns("Solver Add-In") .Installed = False .Installed = True End With oWB.VBProject.References.AddFromFile strSolverPath The situation is that when the user opens the workbook it's being asked for the VBA Project password. The user clicks Cancel and continue without the need to know the password. Is there a way to prevent the code to prompt for password? (I want to keep the code password protected). Thank you for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
prompting for a password | Excel Programming | |||
Excel Macro Prompting | Excel Programming | |||
Prompting 'Save As' in an Excel Macro | Excel Programming | |||
Excel not prompting to save Add-ins | Excel Programming | |||
PASSWORD PROMPTING CODE | Excel Programming |