custom header
 

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?

custom header
 

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?

custom header
 

Thank you for responding, I have the latestest version of excel/ vista

"Gord Dibben" wrote:

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?

custom header
 

On Ribbon...................

InsertHeader and Footer

Click on the Options that you want.

Date.....Time........Sheet Name etc.


Gord


On Tue, 10 Mar 2009 15:06:01 -0700, ct_pws_3
wrote:

Thank you for responding, I have the latestest version of excel/ vista

"Gord Dibben" wrote:

Which version of Excel?

2002 and newer have that functionality when setting up Custom Headers or
Footers.


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 12:58:02 -0700, ct_pws_3
wrote:

Is it possible to link my custom header to the name tab on my work sheet? If
my tab name is March 2009, I don't want to re type this in my print header.
Also can these tabs be automated for example insert current date?