Hi,

My end users will be printing worksheets as a group, i.e. Shift-Clicking to select say 15-30 worksheets in a workbook, then printing. Each worksheet has a footer "Page Number: &P".

I know to set Page Setup --> Page tab --> "First page number" from "Auto" to "1" in order to get my desired numbering, i.e. start at Page 1 when the worksheet changes during group printing. This gives me the same footer whether each worksheet is printed individually or printed as a group.

Can I accomplish the same thing for the footer "Page x of y"? IOW, if each worksheet prints say 3 pages, and I'm group printing 5 worksheets, I want each printout to say "Page 1 of 3" instead of "Page 1 of 15" (for 3 pages).

Thanks,
Scott