title: Excel VBA and Solver: How to suppress dialog box that pops up after hitting time or iteration limits?
body: <p>I use the standard Solver which is part of Excel 2010 in a loop, and every now and then the whole process is halted and a dialog box pops up saying that the maximum number of iterations has been reached, even though I provide UserFinish:=True to the SolverSolve function.
  It prompts the user to continue, stop or abort the procedure. As you can imagine, this is very annoying when you let the machine run alone at night and get up the next morning to see that it got stuck somewhere in the middle.</p>
  
  <p>I'd like to suppress these annoying prompts by pre-defining an answer ("stop!" and move on to the next optimization) to these problems.</p>
  
  <p>Unfortunately, via Google, I've only found attempts to solve this problem, but not definitive answers.</p>
  
  <p>What's today's state-of-the-art solution to this problem, which I assume must be encountered by many users?</p>
  
  <p>Thanks,
  Steve</p>