Solver Macro
 

I want to create a macro that automatically runs solver when a button is
pushed. I went ahead and recorded it, however every time I run it a dialogue
box pops up asking me if I want to keep the solver solution. I always want
to keep the solution and I don't want to have to hit ok every time. My macro
will eventually run other functions after it solves, so I want it to be
smooth and not stopped by this dialogue box. Is there anyway to default this
box to always accept the solution? Any input would be greatly appreciated.

Thanks

Adam Bush

Solver Macro
 

Is there anyway to default this box to always accept the solution?
Any input would be greatly appreciated.

Hi. Add the option True.

SolverSolve True

HTH
Dana DeLouis


wrote:
I want to create a macro that automatically runs solver when a button is
pushed. I went ahead and recorded it, however every time I run it a dialogue
box pops up asking me if I want to keep the solver solution. I always want
to keep the solution and I don't want to have to hit ok every time. My macro
will eventually run other functions after it solves, so I want it to be
smooth and not stopped by this dialogue box. Is there anyway to default this
box to always accept the solution? Any input would be greatly appreciated.

Thanks

Adam Bush

Solver Macro
 

Thank you very much. My problem was I recorded the macro and it didn't save
this setting.

Adam Bush

"Dana DeLouis" wrote:

Is there anyway to default this box to always accept the solution?
Any input would be greatly appreciated.

Hi. Add the option True.

SolverSolve True

HTH
Dana DeLouis


wrote:
I want to create a macro that automatically runs solver when a button is
pushed. I went ahead and recorded it, however every time I run it a dialogue
box pops up asking me if I want to keep the solver solution. I always want
to keep the solution and I don't want to have to hit ok every time. My macro
will eventually run other functions after it solves, so I want it to be
smooth and not stopped by this dialogue box. Is there anyway to default this
box to always accept the solution? Any input would be greatly appreciated.

Thanks

Adam Bush