Page numbering with multiple worksheets

[trishtomorrow]

I have a workbook with multiple worksheets. I want to print the entire workbook and have the page numbering of each worksheet read "page 1 of total number of pages per worksheet" (not the entire workbook); e.g. if worksheet 1 has 23 pages the page numbering will read page 1 of 23, page 2 of 23 and if worksheet 2 has 44 pages the page numbering will read page 1 of 44, page 2 of 44, etc.

I know how to get the total number of pages in the entire workbook to print or how to print each worksheet separately to achieve what I want; however I want to print the entire workbook and get this result.

Thanks in advance.

(P.S. I tried to search and for some reason the search seemed frozen...I would type in a Search and hit Search and nothing happened.)

 

[Andrew Poulsom]

As far as I know the only way to get what you want is to print one worksheet at a time. You could do that via a macro if you want to avoid having to do it manually. The macro recorder should give you the code.

 

[diamondc]

Do you know a macro for this? Adobe Acrobat Pro PDFMaker (add-on for MS Office suite) used to do this automatically when you selected “Sheet(s)” as the conversion range when creating a PDF from an Excel workbook, but the functionality was lost in Acrobat Pro 10. For me, the full request is to do the numbering described by trishtomorrow and also retain the PDF conversion functionality where worksheet tab names become bookmarks in the resulting PDF.