Change the sheetname by changing the value in a specific cell..

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!


Private Sub Worksheet_Change(ByVal Target As Range)
Me.Name = Me.Range("B2").Text

End Sub