View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fries[_2_] Fries[_2_] is offline
external usenet poster
 
Posts: 3
Default How to set Printing quality to Draft?

Hi everybody,

I want to write some code that sets all the sheets´ Printing Quality
to Draft. I have a HP Deskjet 1220.

I tried PageSetup.Prinquality.Draft = True, but that just turns off
ChartPrinting and division lines. I am looking for something to change
the Print- Preferences to Draft.

BTW, creating an extra printer with standard preferences set to draft
does not work for me: as soon as I open a file that has been saved
with "normal" print quality, excel "inherits" the quality from the
file.

anyone?

Fries