Repeat the titles across multiple sheets of a workbook.

[Subodh]

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

 

[Gord Dibben]

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

 

[Subodh]

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



- Show quoted text -

Has any one got VBA code for this

 

[JP]

See http://www.codeforexcelandoutlook.com/blog/2008/04/rows-to-repeat-at-top/

ActiveSheet.PageSetup.PrintTitleRows = "$1:$1"

would repeat row one at the top of each printed page.

--JP

 

[Gord Dibben]

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

 

[Subodh]

Using VBA code you can set the same print range and rows torepeatat 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






- Show quoted text -

This worked but not as i required. This sets the same print range and
rows to repeat at top on
each sheet in grouped sheets. ie. Rows 1:3 in each of each
Sheet1,Sheet2.............. are repeated in their respective pages.
But what i need is to repeat the Rows 1:3 of Sheet 1 to be repeated in
the top of the Sheet1 as well as Sheet2,Sheet3 and other sheets in the
workbook.

 

[Subodh]

This worked but not as i required. This sets the same print range and
rows to repeat at top on
each sheet in grouped sheets. ie. Rows 1:3 in each of each
Sheet1,Sheet2.............. are repeated in their respective pages.
But what i need is to repeat the Rows 1:3 of Sheet 1 to be repeated in
the top of the Sheet1 as well as Sheet2,Sheet3 and other sheets in the
workbook.- Hide quoted text -

- Show quoted text -