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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Blank Page After Envelope-Label Wizard 5
Space at end of multi page list to accommodate new entries 1
batch print some specific pages in multiple word files 1
Insert Work Print Out - Page 1 Above Meeting Info - Other Pages below 0
Text duplication question 0
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
Top Fold Booklet 1

Top