title: Change printer properties in excel macro
body: <p>Is there any way I can change printer properties to color rather than black and white in an Excel macro/Excel VBA? I would like to print in color from the macro but every time I exit excel it sets the color to black and white.  I would like for the macro to set the color back to color every time I run it.  This is the code I am using to print:</p>
  
  <pre><code>Workbooks("Book1.xlsm").Worksheets("Sheet3").PrintOut from:=1, To:=(i / 2) - 0.5
  </code></pre>
  
  <p>This prints every page effected by the macro but it does it in black and white.  I have already tried this but it didn't change anything:</p>
  
  <pre><code>Workbooks("Book1.xlsm").Worksheets("Sheet3").PageSetup.BlackAndWhite = False
  </code></pre>
  
  <p>If it isn't possible to do this in vba I would be fine with an API solution as well.</p>