Chnage name of worksheet tab based on cell

F

facams

New member
Joined
Nov 17, 2017
Messages
4
Reaction score
0
Points
0
Hi, i am having trouble trying to figure out how to change the name of the tabs to correspond with the month along with the day based off a cell in each worksheet.


thank you
 
Change the tab name in the Workbook_SheetChange event.
 
.
Code: 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Me.Name = Me.Cells(1, 1).Value
End Sub
 
You must log in or register to reply here.
Back
Top