Excel 2003 - multiple sheets - reset page numbering

[tsh73]

Hello all,
I need to reset page numbering then printing all workbook so what each sheet was numbered from 1.
Like, sheet1 goes
1 of 3
2 of 3
3 of 3
Then sheet2 goes
1 of 5
2 of 5
...
Is there any way to do it?

 

[tsh73]

ok, I found how _I_ could do it:
just run a macro line
(Alt-F11 Ctrl-G - insert line below - press enter)

for each aSheet in thisWorkbook.Sheets: aSheet.PrintOut: next

But this would be for a customer, so macro won't go.
(file are generated so macros won't carry on [we tried that], but all formatting - will)
Any other options?