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.