How to prevent Solver Results Box from popping up?

  • Thread starter Thread starter ernestgoh
  • Start date Start date
E

ernestgoh

hi,

i wrote a macro to use the solver function and after it finds a
solution, they will pop up a solver results box to ask if you wish to
keep the solver solution or restore original result. my default answer
will be to use the solver solution.

how do i prevent this box from popping up?

is there an option to turn it off?

how do i write a macro to default it to using the solver solution?
 
Make the last line:


SolverSolve True

hi,

i wrote a macro to use the solver function and after it finds a
solution, they will pop up a solver results box to ask if you wish to
keep the solver solution or restore original result. my default answer
will be to use the solver solution.

how do i prevent this box from popping up?

is there an option to turn it off?

how do i write a macro to default it to using the solver solution?
Click to expand...
 
omg!!! it works!!! do you know how much time you have saved me? i am
running the macro for 200+ values. thanks so much!
 
You're welcome! Thanks for letting me know that it helped.
omg!!! it works!!! do you know how much time you have saved me? i am
running the macro for 200+ values. thanks so much!
Click to expand...
 
Back
Top