| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I make a Header stop printing on page 1 only?
|
|
#2
|
|||
|
|||
|
Try this CB
http://www.rondebruin.nl/print.htm#Header -- Regards Ron de Bruin http://www.rondebruin.nl "CB" wrote in message ... |
|
#3
|
|||
|
|||
|
Ron-
Looking at your helpful code I wondered whether you have to specify the "To" parameter. It doesn't look like it, as least this prints page 2 and everything beyond it in Excel 2003 for me: Sub Test() With ActiveSheet.PageSetup .RightHeader = "Your Header info" ActiveSheet.PrintOut From:=1, To:=1 .RightHeader = "" ActiveSheet.PrintOut From:=2 End With End Sub -- Jim "Ron de Bruin" wrote in message ... | Try this CB | | http://www.rondebruin.nl/print.htm#Header | | | -- | Regards Ron de Bruin | http://www.rondebruin.nl | | | "CB" wrote in message ... | | | |
|
#4
|
|||
|
|||
|
Hi Jim
Yes i know But it is easy to change if people do not want to print the last one for example That's why I keep it in the code To:=TotPages -1 -- Regards Ron de Bruin http://www.rondebruin.nl "Jim Rech" wrote in message ... Ron- Looking at your helpful code I wondered whether you have to specify the "To" parameter. It doesn't look like it, as least this prints page 2 and everything beyond it in Excel 2003 for me: Sub Test() With ActiveSheet.PageSetup .RightHeader = "Your Header info" ActiveSheet.PrintOut From:=1, To:=1 .RightHeader = "" ActiveSheet.PrintOut From:=2 End With End Sub -- Jim "Ron de Bruin" wrote in message ... | Try this CB | | http://www.rondebruin.nl/print.htm#Header | | | -- | Regards Ron de Bruin | http://www.rondebruin.nl | | | "CB" wrote in message ... | | | |
|
#5
|
|||
|
|||
|
But it is easy to change
Ahh, I see. -- Jim "Ron de Bruin" wrote in message ... | Hi Jim | | Yes i know | | But it is easy to change if people do not want to print the last one for example | That's why I keep it in the code | | To:=TotPages -1 | | | | -- | Regards Ron de Bruin | http://www.rondebruin.nl | | | "Jim Rech" wrote in message ... | Ron- | | Looking at your helpful code I wondered whether you have to specify the "To" | parameter. It doesn't look like it, as least this prints page 2 and | everything beyond it in Excel 2003 for me: | | Sub Test() | With ActiveSheet.PageSetup | .RightHeader = "Your Header info" | ActiveSheet.PrintOut From:=1, To:=1 | .RightHeader = "" | ActiveSheet.PrintOut From:=2 | End With | End Sub | | | -- | Jim | "Ron de Bruin" wrote in message | ... | | Try this CB | | | | http://www.rondebruin.nl/print.htm#Header | | | | | | -- | | Regards Ron de Bruin | | http://www.rondebruin.nl | | | | | | "CB" wrote in message | ... | | | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
| Printing Recto/Verso | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) | |||
| How do I stop automatic page breaks in excel | Excel Worksheet Functions | |||
Linear Mode
