Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel prompts for VBA password when opening
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Prompts for Links | Excel Discussion (Misc queries) | |||
Opening excel spreadsheets via excel.application object w/o prompts | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
Excel 2003 prompts for the password when I am not opening the stated file. | Excel Programming |