Hi S,
Not sure if there's a solution to this. Probably is, but since you're doing it
by macro, I'd just repeat the print command for each sheet. You can put a
single print code-line into a loop if there's lots of sheets.
Regards - Dave.
> Date: Sat, 9 Jan 2010 11:08:44 -0800
> Subject: $$Excel-Macros$$ printing page numbers of worksheets
> From: shannonw...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi there, this is no doubt a newb question, but I can't find anything
> online.
>
> I have a 'master' workbook containing various formulas (let's call
> that WB1). I import customer data into WB1 as separate worksheets,
> run my formulas, then copy out the resulting customer-specific
> worksheets into a new workbook (let's call it WB2). WB2 has no VBA/
> macros, the data is copied as straight values. I provide WB2 to the
> customer electronically, and also provide a printed copy of each
> worksheet in WB2. Here's my problem:
>
> In WB1, I have a routine to format the printed version for each
> worksheet in WB2. Paper size, margins, font, header/footer, etc. In
> the footer I would like to have page x of x WORKSHEET pages. If each
> worksheet is printed separately, that works fine. But if I print the
> entire WB2 workbook in one shot, the footer displays page x of x
> WORKBOOK pages. Is there a way around this? I am using this code to
> get the footer:
>
> With Worksheets(wsName).PageSetup
> .CenterFooter = "&P of &N"
>
> Thanks in advance, sorry if this is a bit confusing.
>
> S.
_________________________________________________________________
Search for properties that match your lifestyle! Start searching NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe