How to set Printing quality to Draft?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Fries (fries_at_ya.com)
Date: 12/20/04 

Date: 20 Dec 2004 08:31:07 -0800

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

Relevant Pages