Suppress Header/Footer On First Page

Carrie Kaelin

New Member
Joined
Nov 8, 2005
Messages
21
Please advise if there is a way to suppress the header/footer on the first page of your report.

Thanks,
Carrie
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
I think yer gonna hafta use a bit o' VBA to pull that off. I don't know of a built-in option/property that would do the trick. You could write a routine to print just the first page w/o header and then the rest w/ headers. Best way to start is doing it by hand w/ the macro recorder and picking through the code it creates. (The macro recorder has a field-day w/ the PageSetup object so be prepared to just delete off a lot of the properties that you don't want to change.)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,755
Messages
5,574,044
Members
412,565
Latest member
roberttaekim
Top