Different Header on First page in Excel

T

tillville

Is there a way to not have the Header show up on the 1st page of an Excel Spreadsheet?

Would like the answer to this from Excel 2000 and 2003 formats.

Thanks!
 
M

mzehr

Try this from Ron de Bruin posted earlier this spring:

Suppress Header on 1st Page
Sub Test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT
(50)")
With ActiveSheet.PageSetup
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=1, To:=1
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=2, To:=TotPages
End With
End Sub
 
Top