Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make a header in Excel appear on the first page only?
I know how to put a header on an excel spreadsheet but is there a way to make
it appear on the first page only? |
#2
|
|||
|
|||
Take a look at J.E. McGimpsey's site:
http://www.mcgimpsey.com/excel/subs/firstfooter.html Excel headers wrote: I know how to put a header on an excel spreadsheet but is there a way to make it appear on the first page only? -- Dave Peterson |
#3
|
|||
|
|||
Code from Ron de Bruin's site on Print Tips.
http://www.rondebruin.nl/print.htm 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 Gord Dibben Excel MVP On Wed, 27 Apr 2005 14:51:19 -0700, "Excel headers" <Excel wrote: I know how to put a header on an excel spreadsheet but is there a way to make it appear on the first page only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |