After reading a post from last year on this subject I tried to use the following code in the VBA worksheet to make the tab name the same as the date in a specific cell on the same sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "n3"
On Error GoTo ws_exit
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
Me.Name = .Value
Application.EnableEvents = True
Yet, when I hit alt-q to go back and test, I could not get it to work.
This workbook has 52 sheets, one for each week and needing that date for each week on the tab.
Clearly I am doing something wrong and thought you all may have an idea of a solutions.