#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Enquiry

How can I put header at only the top page and footer at only the last page?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Enquiry

You can use a macro to print the sheets. And the macro would adjust the
header/footer for each sheet.

Ron de Bruin has some sample code:
http://www.rondebruin.nl/print.htm#not

Leng wrote:

How can I put header at only the top page and footer at only the last page?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enquiry Form Abidan Excel Worksheet Functions 0 August 15th 06 11:35 AM
Urgent enquiry jiang Excel Worksheet Functions 6 August 10th 06 11:46 AM
A formula enquiry; (screenshots included) PhilK Excel Discussion (Misc queries) 3 May 23rd 06 10:38 AM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"