Hi,

If you are talking about doing this in Excel 2007 - meaning printing it in
Excel not as a pdf, then you can do it

1. Select all the sheets in the workbook and add page number to the custom
footer or however, you want to do that.
2. Then with all the sheets selected issue the print command, the page
numbering will work between sheets.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Budget Programmer" wrote:

Hello,
I've complete a somewhat complex Macro that tests out fine. I'm getting
stuck on something that should be simple, but it's a big problem for me.
I'd like to automate the printout of an entire workbook. I'm creating a PDF
file, and Adobe uses Print to create their file.
It's important that all the pages in my workbook be numbered sequentially.
For example, if Worksheet 1 fit on 3 pages, then Worksheet 2 would start with
a page number of 4.
Can't I feed PrintOut the "Print What" section with "Entire Workbook"
somehow?
I've seen other programs loop through worksheets within a workbook, but the
page numbering would reset to 1 with each page. Isn't the "Entire Workbook"
option available to VBA?
Thanks for all your help.
--
Programmer on Budget