I am using the Solver feature of Excel in some workbooks that I have. At some point a small dialog box pops up requesting the Solver Password. It doesn't seem to prevent me from doing anything, but it won't go away. In fact I can close all my workbooks and the dialog box remains. Nothing will close it short of rebooting my computer. Do you know what this is and how to keep it from appearing?
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Solver Password Box Nuisance
- Thread starter bhujanga
- Start date
In Developer ribbon item display Visual Basic editor. In Project Explorer window find Solver and try to expand the project. Is it the same dialog? If so, I wonder how you can work with this dialog opened, the only idea I have is that you have hidden excel instance and somehow it is forced to open the project.
With wisible password dialog and no excel check windows task manager for any excel instance. If it exists, there can be something set to run excel on startup.
combo
With wisible password dialog and no excel check windows task manager for any excel instance. If it exists, there can be something set to run excel on startup.
combo
- Thread starter
- #3
How odd. I did find an item called SOLVERXLAM in the object list in the VBA Editor area. If I click on it to expand it so that I can access the code, that dialog box pops up and doesn't let me in.
When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it.
When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it.
It's ok, Solver is an excel add-in designed by Microsoft and the VBA project is renamed to "Solver" and password protected. You can't view it. If it's the same password prompt dialog, just close it, can you do it?
The question is when it is displayed:
- after your specific action in excel?
- when you start the computer?
- when you start excel?
- other?
I don't understand "When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it", can you post a screen with this scenario?
combo
The question is when it is displayed:
- after your specific action in excel?
- when you start the computer?
- when you start excel?
- other?
I don't understand "When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it", can you post a screen with this scenario?
combo
The prompt for VBA project password can be displayed automatically in some situations, see: Any other add-ins installed?
combo
combo
- Thread starter
- #6
I can't say for sure when the dialog box first opens. It's definitely not when I start my computer or when I start Excel. At some point as I'm working I will notice that a new Excel "occurrence" has piped up. And it is just that dialog box. It doesn't announce itself by coming to the front when it first opens, it just lurks down there unless I make it the active window. So far today it has not made its appearance, but the last week or so it has been persistent in opening at some point.
What I mean by "When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it", is that if I close all of the Excel files that are open, that dialog box remains and won't let me cancel out of it. If I open Task Manager it shows that Excel has one occurrence open and it is just that dialog box. If I tell Task Manager to make it close, it can't do it. Since it hasn't happened yet today, I can't show you a screen shot.
If I force it to open by clicking on the VBA Code Module, it does close properly when I cancel it, but I don't yet know if that will close it in the case where it has appeared of it's own volition.
I'll take a look at the link you posted
Thanks.
What I mean by "When I have closed all other excel windows the Task Manager does consider this to be an active project, but even Task Manager cannot abort it", is that if I close all of the Excel files that are open, that dialog box remains and won't let me cancel out of it. If I open Task Manager it shows that Excel has one occurrence open and it is just that dialog box. If I tell Task Manager to make it close, it can't do it. Since it hasn't happened yet today, I can't show you a screen shot.
If I force it to open by clicking on the VBA Code Module, it does close properly when I cancel it, but I don't yet know if that will close it in the case where it has appeared of it's own volition.
I'll take a look at the link you posted
Thanks.
It seems that either excel add-in or other application uses hidden excel instance.
Is the code module in one of workbooks or add-ins you wrote? Do you have a reference to Solver library (i.e vba project in your excel application references Solver)?
Do you mean that you can't terminate excel process in Task Manager??
combo
Is the code module in one of workbooks or add-ins you wrote? Do you have a reference to Solver library (i.e vba project in your excel application references Solver)?
Do you mean that you can't terminate excel process in Task Manager??
combo
- Thread starter
- #8
Yes, that is what I mean - the only way I can get it to close is to reboot.
I have VBA code but it's just run of the mill cell manipulation stuff. And I have solver parameters set up in two of the worksheets, but I haven't attempted to reference them from the vba code. I'm having to work on something else for a while at least a few days now that doesn't use any of the workbooks in which I use the solver, so it probably won't happen to me again until I'm back on that type of work again.
I have VBA code but it's just run of the mill cell manipulation stuff. And I have solver parameters set up in two of the worksheets, but I haven't attempted to reference them from the vba code. I'm having to work on something else for a while at least a few days now that doesn't use any of the workbooks in which I use the solver, so it probably won't happen to me again until I'm back on that type of work again.
Check third party COM add-ins. I found info that prompts for password to protected vba projects (regular files or add-ins) occur when any of Google Desktop, Google Desktop Search, Adobe COM Addin (Acrobat PDFMaker Office).
More details by Jon Peltier:
More details by Jon Peltier:
- Status
Similar threads
- Locked
- Question