I would like to be able to set up a template where the name of the tab is the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab name
to become 2007 but if I change A1 to be 2010 the tab name should change too.

You are better off doing it the other way around, which won't require a
macro. Is that possible?
See:
http://www.officearticles.com/excel/...ft_e xcel.htm
************
Anne Troy
www.OfficeArticles.com

"MadMurr" wrote in message
...
I would like to be able to set up a template where the name of the tab is
the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab
name
to become 2007 but if I change A1 to be 2010 the tab name should change
too.

Take a look he

http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"MadMurr" wrote:

I would like to be able to set up a template where the name of the tab is the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab name
to become 2007 but if I change A1 to be 2010 the tab name should change too.

Not sure why requiring a macro would necessarily be a disadvantage.

In many commercial XL applications, the tab itself isn't necessarily
accessible to the user.

If Workbook protection is employed, the tab can't be changed (but a vba
routine can momentarily unprotect the workbook to effect the change).

Both techniques have their uses.

In article ,
"Anne Troy" wrote:

You are better off doing it the other way around, which won't require a
macro. Is that possible?
See:
http://www.officearticles.com/excel/..._a_cell_in_mic
rosoft_excel.htm

Because about 50% of the time when I suggest a macro, people say they're not
allowed to use them or don't want others to have to enable macros or are
just plain afraid of them. I'm sure you've experienced this too? :)
************
Anne Troy
www.OfficeArticles.com

"JE McGimpsey" wrote in message
...
Not sure why requiring a macro would necessarily be a disadvantage.

In many commercial XL applications, the tab itself isn't necessarily
accessible to the user.

If Workbook protection is employed, the tab can't be changed (but a vba
routine can momentarily unprotect the workbook to effect the change).

Both techniques have their uses.

In article ,
"Anne Troy" wrote:

You are better off doing it the other way around, which won't require a
macro. Is that possible?
See:
http://www.officearticles.com/excel/..._a_cell_in_mic
rosoft_excel.htm

Hence my use of the word "necessarily".

If the user wants to enter a value in a cell and have it rename the
worksheet, it's not "better", to my mind at least, to do it the other
way 'round. It's *worse*, because it doesn't do what the user wants, but
it has advantages in some environments.


In article ,
"Anne Troy" wrote:

Because about 50% of the time when I suggest a macro, people say they're not
allowed to use them or don't want others to have to enable macros or are
just plain afraid of them. I'm sure you've experienced this too? :)

Thank you - I will try that and make sure I got it right. In answer to
Anne's first question, it does have to be this way round because I need the
flexibility to start the workbook in different years and don't want to have
to keep adding and deleting sheets just to get them to start the right year -
too awkward for the work to be done.

Cheers

Murray

"JE McGimpsey" wrote:

Take a look he

http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"MadMurr" wrote:

I would like to be able to set up a template where the name of the tab is the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab name
to become 2007 but if I change A1 to be 2010 the tab name should change too.

That was excellent....Thanks for the help!!!

"JE McGimpsey" wrote:

Take a look he

http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
"MadMurr" wrote:

I would like to be able to set up a template where the name of the tab is the
contents of a specific cell (e.g.) if I enter 2007 in A1 I want the tab name
to become 2007 but if I change A1 to be 2010 the tab name should change too.