<div>
have you tried:<br />
<br />
Application.DisplayAlerts = False<br />
<br />
... Code for solver ...<br />
<br />
Application.DisplayAlerts = True<br />
<br />
make sure you turn it back to true or else you won't get alerts when the macro is done running<br />

</div>


have you tried:

Application.DisplayAlerts = False

... Code for solver ...

Application.DisplayAlerts = True

make sure you turn it back to true or else you won't get alerts when the macro is done running


<div>
Actually that does not appear to work either....but I did some further digging and here is the right answer:<br />
<br />
SolverSolve userfinish:=True<br />
<br />
When recording a macro, it records 'SolverSolve', but not the last part.<br />
<br />
If anyone can point me to where documentation on this stuff, I would be happy to award the points.<br />
<br />
Thanks.
</div>


Actually that does not appear to work either....but I did some further digging and here is the right answer:

SolverSolve userfinish:=True

When recording a macro, it records 'SolverSolve', but not the last part.

If anyone can point me to where documentation on this stuff, I would be happy to award the points.

Thanks.

<div>
<div class="content wysiwyg-content">
I used to know how to do this but have forgotten...<br />
<br />
I am running a couple of solver scenarios in sequence, and would rather not click on &quot;OK&quot; to accept the result from each scenario. &nbsp;This action does not show up in the code when recording a macro.
</div>
</div>


I used to know how to do this but have forgotten...

I am running a couple of solver scenarios in sequence, and would rather not click on "OK" to accept the result from each scenario.  This action does not show up in the code when recording a macro.

VBA to Accept Solver result

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.