Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

See this google search result with Dave Peterson and myself posting. The
print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord


On Mon, 5 Oct 2009 06:12:40 -0700 (PDT), Subodh wrote:

On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:
Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP

On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:



I want to repeat the same text in thetitlesacross multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want toprinttitlesby repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the requiredtitlesto multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.- Hide quoted text -

- Show quoted text -

Has any one got VBA code for this