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