hide header on first page

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Header Columns abc... in 2007 1
Different First Page? 2
How do I hide the header and footer on page 1 in Excel? 1
How to Hide Row & Column Headers in Excel ? 3
Change Header on Multiple Sheets without Changing Other Formatting 1
Access Page Header with merge field 0
printing a header in Excel 2
Different First Page 1

Back
Top