Private Sub Worksheet_Activate()
Range("G13").Value = ActiveSheet.Name
End Sub

Put this in worksheet code. After changing the tab name, cell G13 will
reflect the change the next time the sheet is activated.
--
Gary's Student
gsnu200704


"Ken" wrote:

Excel2003 ... Is it possible to have a cell value linked to a TabSheet Name?

My TabSheets are peoples names ... & in a cell within the TabSheet I have
the same name ... If I change TabSheet name ... I would like the name within
the TabSheet cell to change as well ... Can I do this?

Thanks ... Kha