Print Quality

Haluk

Rules Violation
Joined
Oct 26, 2002
Messages
1,075
Hi;

Is there a way to define the print quality of a sheet, with VBA codes? To save the toner ...

I've tried to use the pagesetup.printquality but i couldn't understand what is explained at the related help file.

It should depend on the drivers that the printer is using but, may be via some API calls we can define the quality (without showing the pagesetup dialog box)

Thx anyway....
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
On my Laserjet I have only two print qualities, 300 and 600 dpi. The code to set it is:

ActiveSheet.PageSetup.PrintQuality = 300
ActiveSheet.PageSetup.PrintQuality = 600

The best way to find out how to set it for your printer is to use the Macro recorder while doing it manually.
 
Upvote 0
Thank you Andrew,

I should have tried that but may be i've requested a resolution different then 300 dpi so that the code ended with an error.

Thank you so much, regards from Turkey.
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,714
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top