#1   Report Post  
Posted to microsoft.public.excel.misc
PJ PJ is offline
external usenet poster
 
Posts: 112
Default Headers

Can you have a header with page numbers on it but page1 of a 3 page workbook
doesn't print.

So Page 1 has no header
Page 2 says Page 2
and Page 3 says Page 3
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Headers

Two separate print jobs or VBA macro.

Se Ron de Bruin's site for the VBA code.

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


Gord Dibben MS Excel MVP

On Thu, 28 Dec 2006 13:35:00 -0800, PJ wrote:

Can you have a header with page numbers on it but page1 of a 3 page workbook
doesn't print.

So Page 1 has no header
Page 2 says Page 2
and Page 3 says Page 3


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
Sorting by Column Headers Richard Excel Discussion (Misc queries) 2 June 19th 06 11:55 PM
Copy Headers and Footers between wookbooks Dave Excel Discussion (Misc queries) 1 May 6th 06 03:47 PM
Excel - auto freeze list headers Anorak Excel Worksheet Functions 0 October 23rd 05 02:22 PM
Headers on a Shared Workbook jessica Excel Discussion (Misc queries) 1 April 29th 05 09:46 AM
Help with Headers jessica Excel Discussion (Misc queries) 0 April 6th 05 06:41 PM


All times are GMT +1. The time now is 09:21 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"