Print multiple sheets page # of #, but NOT be total pages in the workbook
I have users who want to be able to choose to print multiple sheets of their workbook, but then have the output show only the total number of pages for the individual worksheet, not the total workbook. The footers have the fields for [page] of [number of pages].
Sheet1 has 2 pages
Sheet2 has 3 pages
So if I print both sheets in one action, all of the page numbers are "# of 5". We would like to have the option to print all of the sheets in one action, but the pages in Sheet1 would say "Page 1 of 2" not "Page 1 of 5." This was the way it used to work in previous versions and they miss it.
I want to eliminate a page from printing.