ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom footer (https://www.excelbanter.com/excel-discussion-misc-queries/194795-custom-footer.html)

dennis

custom footer
 
Is there any way to have a custom header or footer print only on the first
page?
--
Dennis

Dave Peterson

custom footer
 
Maybe...

You could record a macro that changes the header/footer to what you want.
Then print page 1.
Then change the header/footer to its new value.
Then print pages 2-whatever.

Run the macro whenever you want this.

Ron de Bruin has something similar he
http://www.rondebruin.nl/print.htm#not

Dennis wrote:

Is there any way to have a custom header or footer print only on the first
page?
--
Dennis


--

Dave Peterson

Gord Dibben

custom footer
 
Separate print jobs for 1st page then rest of pages.

You could automate it with code but it would still be two distinct print jobs.

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


Gord Dibben MS Excel MVP


On Mon, 14 Jul 2008 12:29:01 -0700, Dennis
wrote:

Is there any way to have a custom header or footer print only on the first
page?




All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com