How do I insert a footer on only the first page of an XL multi page document

With the printer I use, you can go into printer properties and enter a
watermark. You could then put 'Page 1' as a watermark and tick the box to
only appear on the first page.

I have tried this on a different printer and it did not have a watermark
option though.

"Andre" wrote:

How do I insert a footer on only the first page of an XL multi page document

Thank you Dave for your suggestion, however I do not have the watermark
option on either my HP laser nor my HP deskjet printers. I hope your
suggestion will be helpful to other users.

Anyone else have suggestions ?

"Dave Dobson" wrote:

With the printer I use, you can go into printer properties and enter a
watermark. You could then put 'Page 1' as a watermark and tick the box to
only appear on the first page.

I have tried this on a different printer and it did not have a watermark
option though.

"Andre" wrote:

How do I insert a footer on only the first page of an XL multi page document

Andre

See Ron de Bruin's site for macro code.

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


Gord Dibben MS Excel MVP

On Fri, 6 Oct 2006 06:24:01 -0700, Andre
wrote:

Thank you Dave for your suggestion, however I do not have the watermark
option on either my HP laser nor my HP deskjet printers. I hope your
suggestion will be helpful to other users.

Anyone else have suggestions ?

"Dave Dobson" wrote:

With the printer I use, you can go into printer properties and enter a
watermark. You could then put 'Page 1' as a watermark and tick the box to
only appear on the first page.

I have tried this on a different printer and it did not have a watermark
option though.

"Andre" wrote:

How do I insert a footer on only the first page of an XL multi page document

Thank you very, very much Gord !

Andre

"Gord Dibben" wrote:

Andre

See Ron de Bruin's site for macro code.

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


Gord Dibben MS Excel MVP

On Fri, 6 Oct 2006 06:24:01 -0700, Andre
wrote:

Thank you Dave for your suggestion, however I do not have the watermark
option on either my HP laser nor my HP deskjet printers. I hope your
suggestion will be helpful to other users.

Anyone else have suggestions ?

"Dave Dobson" wrote:

With the printer I use, you can go into printer properties and enter a
watermark. You could then put 'Page 1' as a watermark and tick the box to
only appear on the first page.

I have tried this on a different printer and it did not have a watermark
option though.

"Andre" wrote:

How do I insert a footer on only the first page of an XL multi page document