Header on multiple pages...

In Excel 2003, I have a file that has 3 pages. When I print the pages the header shows up on all three pages.

Is there a way to make the header only print on the first two pages and not on the third page?

Thanks!

try

Please Login or Register  to view this content.

put in standard module then tools/ macro/macros click on
NothirdPageHeader to run

I suppose I am much less educated on this than I thought.

Where would I create a standard module?

Thanks!

first thing is if your sheet isnt called sheet1 change
With Sheets("sheet1")
to
With Sheets("yoursheet")

ok to insert module

right click sheet tab
click view code
you will open the vba editor
on toolbar
click insert
click module
a new blank general module will appear in the right hand pane
paste the code in there.
click file
click close and return to excel
run code as previously stated
you could assign this to a command or forms button so you'd just click to print when required.
dont forget to save workbook!