You're welcome.

"Pattie" wrote:

That's what I needed. Thank you!


"JMB" wrote:

Put a custom footer in that looks like this:

&[Page] Of &[Pages]

then right click on one of your worksheet tabs, select "select all sheets"
and print (or print preview to verify this is what you want, without wasting
paper).



"Pattie" wrote:

I have several worksheets in this file and want to print the entire workbook
with page numbers. Can this be done? Thanks.