title: vba : Can't seem to turn off the "making unconstrained variables non-negative" option for Solver
body: <p>After
      SolverReset</p>
  
  <p>I want to switch off the Make Unconstrained Variables Non-Negative option in the vba Solver.</p>
  
  <p>What are the commands to switch off the Make Unconstrained Variables Non-Negative in Solver?</p>
  
  <p>I tried recording a macro to find out but all I got was,</p>
  
  <pre><code>Sub Macro2()
  '
  ' Macro2 Macro
  '
  
  '
      SolverOk SetCell:="$D$26", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$9:$B$12", _
          Engine:=1, EngineDesc:="GRG Nonlinear"
      SolverOk SetCell:="$D$26", MaxMinVal:=2, ValueOf:=0, ByChange:="$B$9:$B$12", _
          Engine:=1, EngineDesc:="GRG Nonlinear"
      SolverSolve
  End Sub
  </code></pre>