Hey there, I am in need of some assistance with a workbook, here is the
scenario:

We have a multiple sheet workbook, each worksheet is multiple pages. We
want to override the footer function to put our own page numbers. So if
there are 25 worksheets, each worksheet having 3 pages each, we want it to
say 1 of 25, 2 of 25, 3 of 25, etc. Instead it is say 1 of 3, 2 of 3, 3 of
3.

Any suggestions.

S

Won't it be 1 of 75, 2 of 75 etc that you want?

Try this, but do a Print Preview first, before committing it to be
printed out:

Group all sheets together - an easy way is to select the first sheet,
then hold down <Shift and click the last sheet, or you can right-click
on the tab and select Group All Sheets.

Now when you do File | Print Preview and click the Next button several
times, does the footer show 1 of 75, 2 of 75 etc? If it does what you
want, then you can click Print.

Don't forget to ungroup the sheets when you have finished (right-click
a sheet tab).

Hope this helps.

Pete

SP wrote:
Hey there, I am in need of some assistance with a workbook, here is the
scenario:

We have a multiple sheet workbook, each worksheet is multiple pages. We
want to override the footer function to put our own page numbers. So if
there are 25 worksheets, each worksheet having 3 pages each, we want it to
say 1 of 25, 2 of 25, 3 of 25, etc. Instead it is say 1 of 3, 2 of 3, 3 of
3.

Any suggestions.

S

Pete, that works, thank you!! I am no longer in Distress :)

"Pete_UK" wrote in message
ups.com...
Won't it be 1 of 75, 2 of 75 etc that you want?

Try this, but do a Print Preview first, before committing it to be
printed out:

Group all sheets together - an easy way is to select the first sheet,
then hold down <Shift and click the last sheet, or you can right-click
on the tab and select Group All Sheets.

Now when you do File | Print Preview and click the Next button several
times, does the footer show 1 of 75, 2 of 75 etc? If it does what you
want, then you can click Print.

Don't forget to ungroup the sheets when you have finished (right-click
a sheet tab).

Hope this helps.

Pete

SP wrote:
Hey there, I am in need of some assistance with a workbook, here is the
scenario:

We have a multiple sheet workbook, each worksheet is multiple pages. We
want to override the footer function to put our own page numbers. So if
there are 25 worksheets, each worksheet having 3 pages each, we want it
to
say 1 of 25, 2 of 25, 3 of 25, etc. Instead it is say 1 of 3, 2 of 3, 3
of
3.

Any suggestions.

S

Ok, thanks for feeding back.

Pete

SP wrote:
Pete, that works, thank you!! I am no longer in Distress :)

"Pete_UK" wrote in message
ups.com...
Won't it be 1 of 75, 2 of 75 etc that you want?

Try this, but do a Print Preview first, before committing it to be
printed out:

Group all sheets together - an easy way is to select the first sheet,
then hold down <Shift and click the last sheet, or you can right-click
on the tab and select Group All Sheets.

Now when you do File | Print Preview and click the Next button several
times, does the footer show 1 of 75, 2 of 75 etc? If it does what you
want, then you can click Print.

Don't forget to ungroup the sheets when you have finished (right-click
a sheet tab).

Hope this helps.

Pete

SP wrote:
Hey there, I am in need of some assistance with a workbook, here is the
scenario:

We have a multiple sheet workbook, each worksheet is multiple pages. We
want to override the footer function to put our own page numbers. So if
there are 25 worksheets, each worksheet having 3 pages each, we want it
to
say 1 of 25, 2 of 25, 3 of 25, etc. Instead it is say 1 of 3, 2 of 3, 3
of
3.

Any suggestions.

S