Take a look he

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

In article ,
Neil Mitchell-Goodson <Neil
wrote:

In Excel 2003, is there any way to name a worksheet according to user input
in the sheet itself? So if I had a sheet with figures on it, and I specify a
cell to input say, the 'year', that the worksheet would then adopt it's name
from that input?