Posted to microsoft.public.excel.programming

Oscar

external usenet poster

Posts: 35

Can PrintTitleRows method be restricted to a region instead of the whole worksheet ?

I use the PrintTitleRows method for printing at top of each new page such as
ExcelSheet.PageSetup.PrintTitleRows= "$30:$30" . However, the last part of a
report which is printed should not display this toprow. Therefore I was
wondering whether there is a way or trick to have a region to which the
Titlerows can be restricted to.

regards,
Oscar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste values all cells in a region which refers to out of region	Vijay	Excel Worksheet Functions	0	August 25th 09 06:03 AM
restricted permission for worksheet	Naveen	Excel Discussion (Misc queries)	1	July 5th 08 03:00 PM
Restricted Worksheet	Philip Drury	Excel Discussion (Misc queries)	1	March 28th 07 02:14 AM
Restricted Worksheet	Max	Excel Discussion (Misc queries)	1	March 28th 07 02:02 AM
I cannot see my worksheet I think I restricted it somehow	Laurice	Excel Worksheet Functions	2	June 14th 05 01:29 AM

All times are GMT +1. The time now is 12:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us