Take a look he

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


In article ,
"Husker87" wrote:

I have the same question but just want to link one worksheet tab name
automatically to a cell in the worksheet. Change the cell and the tab name
on the worksheet changes€¦ can you help with the VBA code for that? Many
Thanks€¦.