Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
All-in-one printing incompatibility with EXCEL in landscape mode | New Users to Excel | |||
half page extra blank in Landscape mode PRINTING | Excel Discussion (Misc queries) | |||
half page extra blank in Landscape mode PRINTING | Excel Discussion (Misc queries) | |||
Printing Color-Coded Worksheet in Black & White Mode in Excel 2003 | Excel Worksheet Functions | |||
Printing Excel in Landscape mode... | Excel Programming |