Printing of pages

C

Charles Eaves

Sorry for the newbie question.
Can you specify in Excel 2007, the order for pages to be printed out without
manually rearranging them yourself?
Thanks
 
J

JBeaucaire

You could create your own macro that prints the sheets in the order you want
regardless of their location on the wbook:

Sub aPrint()
Sheets("Sheet3").PrintOut copies:=1
Sheets("Sheet1").PrintOut copies:=1
Sheets("Sheet2").PrintOut copies:=1
End Sub
 
Top