Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Page Numbers in Excel
I have a workbook that has about 80 worksheets in it. Each worksheet has a
different number of pages. I want to print the entire workbook at the same time but with page numbering that is specific to each workbook. For example: Worksheet # 1 has 3 pages and workbook #2 has 5 pages. I need 1 of 3, then 2 of 3 and so on to print on worksheet #1 and 1 of 5 then 2 of 5 and so on on worksheet #2. I have footers set up for each worksheet but when I select to print the entire workbook the # of # changes to the total # of pages in the entire workbook so I end up with 1 of 304 on page one of worksheet #1 and it continues through all pages that way, 2 of 304, 3 of 304. Any suggestions? |
#2
|
|||
|
|||
The "of" number always reflects the number of pages in the entire print job.
I can only suggest a macro that prints each worksheet successively one at a time. -- Jim "Terri D." <Terri wrote in message ... |I have a workbook that has about 80 worksheets in it. Each worksheet has a | different number of pages. I want to print the entire workbook at the same | time but with page numbering that is specific to each workbook. For example: | Worksheet # 1 has 3 pages and workbook #2 has 5 pages. I need 1 of 3, then | 2 of 3 and so on to print on worksheet #1 and 1 of 5 then 2 of 5 and so on on | worksheet #2. I have footers set up for each worksheet but when I select to | print the entire workbook the # of # changes to the total # of pages in the | entire workbook so I end up with 1 of 304 on page one of worksheet #1 and it | continues through all pages that way, 2 of 304, 3 of 304. Any suggestions? |
#3
|
|||
|
|||
And how would I do that?
"Jim Rech" wrote: The "of" number always reflects the number of pages in the entire print job. I can only suggest a macro that prints each worksheet successively one at a time. -- Jim "Terri D." <Terri wrote in message ... |I have a workbook that has about 80 worksheets in it. Each worksheet has a | different number of pages. I want to print the entire workbook at the same | time but with page numbering that is specific to each workbook. For example: | Worksheet # 1 has 3 pages and workbook #2 has 5 pages. I need 1 of 3, then | 2 of 3 and so on to print on worksheet #1 and 1 of 5 then 2 of 5 and so on on | worksheet #2. I have footers set up for each worksheet but when I select to | print the entire workbook the # of # changes to the total # of pages in the | entire workbook so I end up with 1 of 304 on page one of worksheet #1 and it | continues through all pages that way, 2 of 304, 3 of 304. Any suggestions? |
#4
|
|||
|
|||
If you want to print all the sheets it could be as simple as this:
Sub PrintAllWSheets() Dim WS As Worksheet For Each WS In Worksheets WS.PrintOut Next End Sub -- Jim "Terri D." wrote in message ... | And how would I do that? | | "Jim Rech" wrote: | | The "of" number always reflects the number of pages in the entire print job. | I can only suggest a macro that prints each worksheet successively one at a | time. | | -- | Jim | "Terri D." <Terri wrote in message | ... | |I have a workbook that has about 80 worksheets in it. Each worksheet has a | | different number of pages. I want to print the entire workbook at the | same | | time but with page numbering that is specific to each workbook. For | example: | | Worksheet # 1 has 3 pages and workbook #2 has 5 pages. I need 1 of 3, | then | | 2 of 3 and so on to print on worksheet #1 and 1 of 5 then 2 of 5 and so on | on | | worksheet #2. I have footers set up for each worksheet but when I select | to | | print the entire workbook the # of # changes to the total # of pages in | the | | entire workbook so I end up with 1 of 304 on page one of worksheet #1 and | it | | continues through all pages that way, 2 of 304, 3 of 304. Any | suggestions? | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open excel from htm page | Excel Discussion (Misc queries) | |||
Excel should let hyperlink of PDF jump to a specific page like IE. | Excel Discussion (Misc queries) | |||
changing page break in an excel file | New Users to Excel | |||
Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |