Prev: The message EUROTOOL.XLA!fshow TTO Dialog cannot be found
Next: .xlsx file opens as read-only
From: Rob on 1 Sep 2007 16:14
I have a 12 sheet workbook. I want to create headers with the format

xxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx &Tab

so when it prints - the actual tab name prints. I have tried using the
Repeat page setup, but it puts the name of the tab I copied from as &Tab.

How is I create one header and have it repeat on each sheet with the correct
TAB name in it...

Please help

Rob_Evelyn(a)msn.com
From: Earl Kiosterud on 1 Sep 2007 16:48
Rob,

The &Tab code should put the individual sheet name in the header, even if used via Repeat
Page Setup. I tested it with Excel 2003.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Rob" <Rob(a)discussions.microsoft.com> wrote in message
news:199D4DFD-033E-44DD-AAC2-83BE710C8023(a)microsoft.com...
>I have a 12 sheet workbook. I want to create headers with the format
>
> xxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxx &Tab
>
> so when it prints - the actual tab name prints. I have tried using the
> Repeat page setup, but it puts the name of the tab I copied from as &Tab.
>
> How is I create one header and have it repeat on each sheet with the correct
> TAB name in it...
>
> Please help
>
> Rob_Evelyn(a)msn.com


 | 
Pages: 1
Prev: The message EUROTOOL.XLA!fshow TTO Dialog cannot be found
Next: .xlsx file opens as read-only