Footer on Last Page only

[patterson]

Here is a good one:
I have a user who wants to put a Footer at the end of his documents no
matter how many pages they are, he just wants it on the last page. I
have a Macro to put the Footer, but if the document is more than 2
pages, the Footer ends up on all pages except the first. Any ideas?

 

[Greg Maxey]

Patterson,

How about a conditional IF field.

{ IF { PAGE } = { NUMPAGES } "Your Footer Text" }

 

[jujuwillis]

Have you considered using an Endnote? (Insert>Footnote>Endnote)
Then no matter how long the document is, it will be at the end

 

[Dorothy Taylor]

Just use section breaks - whether you have one page or
many. This will only work if you always have a template
document where you only use two sections in the entire
document. This way, you put a "next page" section break
on page one and then you have two separate footers.
The second footer will always display the relevant
information. If your document only has information for
one page, you just leave page one "intentionally blank".

 

[Suzanne S. Barnhill]

This doesn't answer the question the OP asked, which was how to have a
footer only on the last page. Although this could be done with a section
break, there are other ways to do it (which have already been posted). To do
what you suggest does not require a section break, only the "Different first
page" setting on the Layout tab of Page Setup.

Just use section breaks - whether you have one page or
many. This will only work if you always have a template
document where you only use two sections in the entire
document. This way, you put a "next page" section break
on page one and then you have two separate footers.
The second footer will always display the relevant
information. If your document only has information for
one page, you just leave page one "intentionally blank".

-----Original Message-----

Here is a good one:
I have a user who wants to put a Footer at the end of his documents no
matter how many pages they are, he just wants it on the last page. I
have a Macro to put the Footer, but if the document is more than 2
pages, the Footer ends up on all pages except the first. Any ideas?


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.