hide header on first page

F

Frank Kabel

Hi
not possible with a VBA macro which will first print the first page
without a header, then apply the header and print all other pages. Try
recording a macro while doing this manually
 
R

Ron de Bruin

Try this karin

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