Hi JLGWhiz,

Your quote "but it would not accomodate the page numbering that you want."

Under testing in both xl2002 and xl2007, ActiveWorkbook.PrintOut Copies:=1,
Collate:= True sequentially numbers the pages for the entire workbook.
Shane's suggestion also works in both xl2002 and xl2007. As an added extra,
the page setup can be different for each worksheet but how much different I
am not sure but they can certainly have different headers and the page
numbering is still sequential for the entire workbook and Page X of Y pages
also works.

As per my previous post, selecting file-print and then setting Entire
workbook also works in xl2002 and with xl2007 Microsoft button - Print -
Print Select printer ....etc then as for xl2002.
--
Regards,

OssieMac


"JLGWhiz" wrote:

Using the ActiveWorkbook.PrintOut would pring all of the pages in the
workbook for each worksheet, but it would not accomodate the page numbering
that you want. You would have to create a special file in another
application to get the page numbering.

"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