View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default change PrintQuality to save ink

Maybe?

With ActiveSheet.PageSetup
.Draft = True
End With


Gord Dibben MS Excel MVP

On Sat, 2 Dec 2006 06:02:00 -0800, ernie
wrote:

i need to make changes to the printQuality to enable me to save ink and have
my printer print faster. How do i accomplish that in vba coding?