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
 
You must log in or register to reply here.

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

Word want to batch print some specific pages in multiple word files 0
How can we convert OST to PDF file format? 1
still can't put these pages in order 2
Need to make page numbers sequential across worksheets 2
Using header on first page only 2
Epson XP-3150 not printing 2
Need help formatting a sheet 0
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2

Back
Top