Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to restrict the TitleRow only for a specific range of rows?
How can I configure Excel such that the TitleRow
(ActiveSheet.PageSetup.PrintTitleRows = "$2:$2" ) which appears at the top of each page that is printed, should only be displayed for a specific range of rows, not for the entire worksheet ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to restrict the TitleRow only for a specific range of rows?
To the best of my knowledge you can't... That is why (in the perfect world)
you only want to put one thing on one sheet. Keeps life simple and makes printing easier... "Oscar" wrote: How can I configure Excel such that the TitleRow (ActiveSheet.PageSetup.PrintTitleRows = "$2:$2" ) which appears at the top of each page that is printed, should only be displayed for a specific range of rows, not for the entire worksheet ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I restrict a text column to a specific number of characters? | Excel Discussion (Misc queries) | |||
Restrict add rows and columns | Excel Discussion (Misc queries) | |||
Restrict showing full range of Y axis | Charts and Charting in Excel | |||
Restrict User to specific cell | Excel Discussion (Misc queries) | |||
How do I remove toolbars and specific menus items to restrict use? | Excel Programming |