title: Solver VBA hide dialog box, still appears
body: <p>I know there are several topics on this, but in my case it doesn't work. I have a macro to iterate through a series of rows, optimising price for every product. I don't want my macro to display the dialog box for every row.</p>
  <pre><code>Sub MultipleSolver()
  Dim i As Integer
  ActiveWorkbook.ActiveSheet.Activate
  For i = 5 To 20
  SolverReset
  SolverOk SetCell:=&quot;$K$&quot; &amp; i, MaxMinVal:=1, ByChange:=&quot;$B$&quot; &amp; i, Engine:=1
  SolverAdd CellRef:=&quot;$B$&quot; &amp; i, Relation:=1, FormulaText:=&quot;$E$&quot; &amp; i
  SolverAdd CellRef:=&quot;$F$&quot; &amp; i, Relation:=1, FormulaText:=&quot;$G$&quot; &amp; i
  
  SolverSolve UserFinish:=True
  
  Cells(i, &quot;L&quot;).Value = SolverSolve
  
  Next i
  
  End Sub
  </code></pre>
  <p>UserFinish:=True is supposed to omit the dialog box, however it still shows the dialog box for every row. Many thanks!.</p>