software

How to print heading on everypage for all sheets of a workbook.
I grouped all sheets, then went as File-gt;pagesetup-gt;sheet tab, but i
see print titles option is disabled, why. But for single sheet it is
working. Please suggest how to enable it for *all sheets*.
THANKS--
jamex
------------------------------------------------------------------------
jamex's Profile: www.excelforum.com/member.php...oamp;userid=32243
View this thread: www.excelforum.com/showthread...hreadid=520432I don't think you can. You'll have to go through each sheet.

jamex wrote:
gt;
gt; How to print heading on everypage for all sheets of a workbook.
gt; I grouped all sheets, then went as File-gt;pagesetup-gt;sheet tab, but i
gt; see print titles option is disabled, why. But for single sheet it is
gt; working. Please suggest how to enable it for *all sheets*.
gt; THANKS
gt;
gt; --
gt; jamex
gt; ------------------------------------------------------------------------
gt; jamex's Profile: www.excelforum.com/member.php...oamp;userid=32243
gt; View this thread: www.excelforum.com/showthread...hreadid=520432

--

Dave Peterson

Excuse the work wrapping, but this should help (adjust to your needs).

Customize the Page Sections (Header/Footer)of a worksheet as desired.
Then from this
same worksheet - run this macro:

Sub change_all_headers()
With ActiveSheet
LF = .PageSetup.LeftFooter
CF = .PageSetup.CenterFooter
RF = .PageSetup.RightFooter
LH = .PageSetup.LeftHeader
CH = .PageSetup.CenterHeader
RH = .PageSetup.RightHeader
End With

For Each sht In Sheets
sht.Select
ActiveSheet.PageSetup.LeftFooter = LF
ActiveSheet.PageSetup.CenterFooter = CF
ActiveSheet.PageSetup.RightFooter = RF
ActiveSheet.PageSetup.LeftHeader = LH
ActiveSheet.PageSetup.CenterHeader = CH
ActiveSheet.PageSetup.RightHeader = RH
Next sht
End Sub

Report back, if problems.
Remember to back up you r file before trying ANYTHING NEW!!

quot;jamexquot; gt; wrote in
message ...
gt;
gt; How to print heading on everypage for all sheets of a workbook.
gt; I grouped all sheets, then went as File-gt;pagesetup-gt;sheet tab, but i
gt; see print titles option is disabled, why. But for single sheet it is
gt; working. Please suggest how to enable it for *all sheets*.
gt; THANKS
gt;
gt;
gt; --
gt; jamex
gt; ------------------------------------------------------------------------
gt; jamex's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32243
gt; View this thread: www.excelforum.com/showthread...hreadid=520432
gt;

I had the same problem and this sorted it - thanks Jim.--
tonywig------------------------------------------------------------------------
tonywig's Profile: www.excelforum.com/member.php...oamp;userid=18985
View this thread: www.excelforum.com/showthread...hreadid=520432