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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

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,850
Messages
5,574,652
Members
412,607
Latest member
caner
Top