name of sheet
 

How do I create a link so that the name of my sheet is equal to data in a
cell? Currently I am re-naming each sheet tab, there has to be an easier way?

Thank you

You need VBA

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then
Sh.Name = Target.Value
End If
End Sub

put the code in the ThisWorkbook code module.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Maria" wrote in message
...
How do I create a link so that the name of my sheet is equal to data in a
cell? Currently I am re-naming each sheet tab, there has to be an easier
way?

Thank you