Auto naming tabs?

[bobjglover@gmail.com]

Hello Gurus,

Is there a way to enter information into a cell and it auto populate the name of that tab?

[navic]

a cell and it auto populate the name of that tab?

This VBA macro you copy in 'ThisWorkbook' module of your Workbook

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$A$1" Then 'adress of cell where is name of sheet
ActiveSheet.Name = [A1]
End If
End Sub

[bobjglover@gmail.com]

Ty, where is'this workbook module' located? In the same workbook?

[navic]

Ty, where is'this workbook module' located? In the same workbook?

Yes, in the same workbook
I gave you the link (post up above)
Look at the 5th image

btw:
- Right-click on the some tab name
- pop-up menu => View code
- In the VBE you can see "ThisWorkbook" module, below the sheet name (Excel 2013)