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? |
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 |
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? |
All times are GMT +1. The time now is 04:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com