View Single Post
  #3   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

Of course... which I did without succes.
JP
"Jim Rech" schreef in bericht
...
Try setting Draft to True.

--
Jim Rech
Excel MVP
"Jean-Paul De Winter" wrote in message
...
| 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
|
|