See

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

In article ,
"Tony4X4" wrote:

Hi there,
Thanks for reading my question.
Is it possible to name a sheet from a cell value with in the sheet? i.e. I
have 12 sheets, each sheet represents a month and the month value is in cell
A1. Can I rename a sheet by refering to cell A1 instead of manually renaming
the sheets to January, February etc.

Many thanks

Tony