I have a workbook with multiple worksheets tabs. I use the Page X of Y on
each page footer. When I print a single worksheet from the group, the footer
prints "Page 1 of 1", even if it is really sheet 5 of the group. How can I
print single pages with the correct page numbers?