Specifiying Successive Page Numbers for Workbooks with Multiple Tabs/Pages

[M.P.]

Hi,
Does anyone know how to make a workbook with several tabs
print with successive page numbers from the first page of
the first tab to the last page of the last tab?
Thanks

 

[Andy B]

Hi

Select all of the tabs and then print the lot in one go!!

 

[M.P.]

I have tried that before, but each tab has pages 1, 2, 3,
etc.

 

[Andy B]

Well, I've just tried it on mine (XL2K) and it numbers the pages from 1 all
the way through to the end.

 

[M.P.]

Dumb Questions -
1) How did you select multiple tabs - Using the Control
key to select multiple tabs, or using shift first to last
to select all?
2) How did you insert page numbers so they are successive?
Thx