What:
Well the title says it all.. the sheetname will change when you change the value of a cell (in the example below cell “B2”)
Note! Don’t put this code in a separate module, but in the VBA of the actual sheet!
VBA:
Private Sub Worksheet_Change(ByVal Target As Range)
Me.Name = Me.Range("B2").Text
End Sub