I have many workbooks which contain many worksheets. Some of the worksheets have multiple pages.
Currently, I have to manually enter all the page numbers in the header (i.e. Page 1 of 87). The total number of pages includes all the worksheets (and all of their pages).
I have looked through VBA help and tried a number of combinations of the formatting codes for headers, and none of them differentiates the different worksheets. By this, each worksheet starts over as page 1.
Any suggestions? The major reason I want to be able to do this is I want to be able to add / subtract worksheets and NOT have to manually changes all the headers.
Currently, I have to manually enter all the page numbers in the header (i.e. Page 1 of 87). The total number of pages includes all the worksheets (and all of their pages).
I have looked through VBA help and tried a number of combinations of the formatting codes for headers, and none of them differentiates the different worksheets. By this, each worksheet starts over as page 1.
Any suggestions? The major reason I want to be able to do this is I want to be able to add / subtract worksheets and NOT have to manually changes all the headers.