Different Header on First page in Excel

[Guest]

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!

 

[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

 

[Ron de Bruin]

http://www.rondebruin.nl/print.htm#Header