Hi Janet
Only possible with code
The example below will only print the right header on the first page of
the ActiveSheet.
You have this options
(LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, RightFooter)
Check out the VBA help for all formatting codes.
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 = ""
ActiveSheet.PrintOut From:=2, To:=TotPages
End With
End Sub