I'm trying to achieve your first point here. However when I group and apply
the footer "Pages 1 of ?" it removes my page breaks on the sheet which 3
pages.
"RagDyeR" wrote:
Are you saying that you want the 3 *Print Pages* of Sheet 1 to display,
"Page 1 of 14"?
AND ... have Sheet 2 display "Page 2 of 14"?
If you manually set the page breaks, and then Group and print the WB, the
page breaks remain in force, and pick up their own page number.
So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each,
you'd end up with 16 page numbers.
What *exactly* are you looking to accomplish?
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------
"Adam" wrote in message
...
Some of the worksheets print over 3 pages, so grouping and then adding the
the footer removes the page breaks on those pages.
"RagDyeR" wrote:
Group your Worksheets before printing.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Adam" wrote in message
...
Hi All,
I've add the page footer pages # of # however on each page its coming up
with 1 of 1.
There are about 14 worksheets in the workbook so why isn't it showing 1 of
14 on the last sheet?
--
Adam
-----------
Windows 98 + Office Pro 97
|