From: OMER on 26 Jan 2010 13:47
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
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
Prev: form combobox auto expand
Next: List of names that can be divide by catagory in a single step