Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook page numbering
My workbook pages are divided into pages---
When printing the entire workbook, I would like to the page numbering start over for each page in the workbook. As I print the entire workbook, numbering is 1 of 40, 2 of 40 - etc I would like 1 of 10 for the first page - 1 of 5 for the second page, etc as I print the entire workbook. Can this be done. Jackie -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook page numbering
You could try a macro:
Sub Print_All dim wksTemp as sheet On Error Resume Next for each wksTemp in sheets wksTemp.Printout copies:=1 next wkstemp End Sub "Jost" wrote: My workbook pages are divided into pages--- When printing the entire workbook, I would like to the page numbering start over for each page in the workbook. As I print the entire workbook, numbering is 1 of 40, 2 of 40 - etc I would like 1 of 10 for the first page - 1 of 5 for the second page, etc as I print the entire workbook. Can this be done. Jackie -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Page Numbering starting on 3 | Excel Discussion (Misc queries) | |||
Format page numbering to be Page 1 of X | Excel Discussion (Misc queries) | |||
Auto page numbering for several worksheets | Excel Worksheet Functions | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |