| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PRINTING TWO PAGES TO FIT ON ONE | Excel Discussion (Misc queries) | |||
| How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
| Printing Odd or Even Pages | Excel Discussion (Misc queries) | |||
| PRINTING PAGES | Setting up and Configuration of Excel | |||
Linear Mode
