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