Thread: Headers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
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