this code under INPUTS code:
and this code in a module (insert Module)![]()
Private Sub Worksheet_Change(ByVal Target As Range) Dim new_name As String Dim ws As Worksheet If Target.Column = 2 And Target <> "" Then Set ws = Sheets(old_name) ws.Name = Target.Value End If End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 2 And Target <> "" Then old_name = Target.Value End If End Sub
![]()
Option Explicit Public old_name As String
Bookmarks