View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
 
Posts: 46
Default Printing in Draft mode

Hi,
I created a pushbutton with following code:

Sub printfile()
Dim I As Integer
For I = 2 To Sheets.Count
With ActiveSheet.PageSetup
.Draft = False
End With
Sheets(I).PrintOut
Next I
End Sub

The idea is to print sheets in draft mode... however, I doubt if this is the
correct code since it doesn't seem to work...
Any idea?
Thanks