I only need the center footer to read differently on each page. For
example, on page 1, it should read "Net Cash Flows" and on page 2, it should
read "Net Working Capital", and on page 3, it should read "Summary Tables",
etc. If I enter the center footer on page 1, it is automatically copied to
the remaining pages. Do I have any other options?
Thank you for your help.

"Gord Dibben" wrote:

A unique footer on each page would require a separate setup for each page anda
print job for each.

You could do it with VBA but it would still wind up as separate print jobs.

See Ron de Bruin's site for sample code which would have to be modified.

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

On Sat, 26 Apr 2008 11:35:00 -0700, bailey
wrote:

I have multiple pages on one worksheet.

"Gord Dibben" wrote:

Bailey

A "page" is generally considered to be the area of a worksheet that will print
on one sheet of paper. You could have multiple pages on one worksheet and
multiple worksheets in a workbook, each with multiple pages to print.

Do you mean each "worksheet" of a workbook to have different footers for the
pages printed from that worksheet?

Or different footers for each page printed from a single worksheet?

This would be done manually in most cases.

You could do it with VBA code but need a couple of the questions above answered.


Gord Dibben MS Excel MVP


On Sat, 9 Feb 2008 08:35:01 -0800, Bailey
wrote:

How can I enter different footers on each page in a workbook without all
pages having the same footer?