Auto naming tabs?

B

bobjglover@gmail.com

New member
Joined
Aug 3, 2015
Messages
57
Reaction score
0
Points
0
Excel Version(s)
1901
Hello Gurus,

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

bobjglover@gmail.com said:
a cell and it auto populate the name of that tab?
Click to expand...
This VBA macro you copy in 'ThisWorkbook' module of your Workbook
Code: 
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 said:
Ty, where is'this workbook module' located? In the same workbook?
Click to expand...
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)
 
You must log in or register to reply here.
Back
Top