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.