I have a workbook with 3 sheets. Each of these sheets can contain up to 5 pages. The formatting is different on each sheet.
My customer wants to see "Page x of y" written in a certain cell (not in the header - that would be too easy ) and y = number of pages in the workbook!
I found some scripts that can determine the number of pages in a sheet but none that can determine the number of pages in the whole workbook.
Anybody got any hint how to solve this problem?

Thanks, Harry