Printing of pages

  • Thread starter Thread starter Charles Eaves
  • Start date Start date
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
 
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
 
Back
Top