Page Numbers on Workbook with Many Sheets

[fedas18]

Hey,

I have an excel workbook with about 7 sheets. On the top of each sheet there is a macro bottom "print":

Sub Macro15()
'
' Macro15 Macro
'
'
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,3,,,TRUE,,FALSE)"
End Sub


All of the sheets print on 1 page except for 1 sheet which prints on 3. So when your press print, 10 pages actually print. When I print it, I would like it to say 1 of 10, 2 of 10 ect. Or 1 of 7, 2 of 7, 3a of 7, 3b of 7, 3c of 7 (for the sheet with multiple pages).

When I try to add this in the footer, it only does the # of pages for that specific sheet (1 of 1 or 1 of 3).

Can I somehow fix this? Maybe add it to the macro?

Thanks!

 

[GlennUK]

If you select all the tabs first and then print they will print with the right page numbers. Except for the 7a 7b 7c thing .... there is no easy way to do that ... you'd need to adjust the footer between each single page of that 3 page print.