Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to start a header on the 2nd page and not have it on the 1st. Is that
possible in Excel? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
just with VB. copy this module (change to your header text) print the first time, execute this code, print the other pages. hth regards from Brazil Marcelo ****************************************** Sub Header() With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" End With ActiveSheet.PageSetup.PrintArea = "" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "your header here" .RightHeader = "" .LeftFooter = "" .CenterFooter = "" .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.787401575) .RightMargin = Application.InchesToPoints(0.787401575) .TopMargin = Application.InchesToPoints(0.984251969) .BottomMargin = Application.InchesToPoints(0.984251969) .HeaderMargin = Application.InchesToPoints(0.492125985) .FooterMargin = Application.InchesToPoints(0.492125985) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = 600 .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperLetter .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False .Zoom = 100 .PrintErrors = xlPrintErrorsDisplayed End With End Sub ****************************************** "mindela85" escreveu: I want to start a header on the 2nd page and not have it on the 1st. Is that possible in Excel? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi mindela85
Only if you print with code http://www.rondebruin.nl/print.htm#Header -- Regards Ron de Bruin http://www.rondebruin.nl "mindela85" wrote in message ... I want to start a header on the 2nd page and not have it on the 1st. Is that possible in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
Open excel from htm page | Excel Discussion (Misc queries) | |||
Default header in Excel under page set-up | Excel Discussion (Misc queries) |