ExcelBanter - Printing of pages

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Printing of pages (https://www.excelbanter.com/new-users-excel/225656-printing-pages.html)

Printing of pages

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

Printing of pages

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

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.

"Charles Eaves" wrote:

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