You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nicci" wrote in message
...
Fantastic... Thanks so much

"RagDyer" wrote:

All you have to do is go to,
<File <PageSetup <Page tab,
And change the "First Page Number" from Auto to 1.

You can group all your sheets and make this change at one time.

One glitch *may* be ... if you use the total print job number per sheet:
Page n of n

That second n will display the total pages for the *entire* print job, not
just the number of pages per sheet.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nicci" wrote in message
...
I have a workbook I maintain with MANY worksheets showing price lists for
different accounts. Each worksheet has several pages. I want the
footer
to
print the page # for the worksheet, not the page # of the workbook. In
other
words, pages 1,2,3 on worksheet 2 should also read 1,2,3 not 4,5,6.
When
I
print each sheet individually the page #s are correct but when we print
the
entire workbook, it shows the wrong #s. Is there an Easy way of doing
this?
Other people in the office are doing the printing (the easy way) and
sending
out mailings with bad page #s. Help?