View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dab1984 dab1984 is offline
external usenet poster
 
Posts: 1
Default Need help writing a printing macro

Running Office 2003. Printer is new Ricoh Aficio 3245C PCL 5c. Default color
setting is black and white. Sometimes want to print a spreadsheet in color.
Know one can manually change the color setting from b&w to color via the
printer's printing preferences. Would like to have a macro that makes this
change and then reset back to the default b&w. Know how to create a custom
button on a toolbar and assign the macro. But unable to write a macro that
does the trick.
Thanks for your feedback.