| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Header
How do I keep the header from printing on every page but the first?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Header
Don't make it a header.
"Medical Records" wrote: How do I keep the header from printing on every page but the first? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Header
From Ron deBruin's site on Print Tips
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 For more tips on headers/footers see Ron's pages at http://www.rondebruin.nl/print.htm Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 12:51:01 -0700, Medical Records <Medical wrote: How do I keep the header from printing on every page but the first? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| Header & Footer Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
| Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) | |||
| Default header in Excel under page set-up | Excel Discussion (Misc queries) | |||
Linear Mode
