I want to match the name of a worksheet tab with the header of a form. In other words, if I type the name of the form in a header (a
cell), the worksheet tab would change the name to match the header name.
Here's what I'm using but it's not working:
Private Sub workbook_SheetChange(ByVal sh As Object, ByVal target As Range)
If target.Address = "$d$1" Then sh.Name = target
End Sub
Can anyone tell me what I'm doing wrong? THANKS!
Bookmarks