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!


--
jerrystan
------------------------------------------------------------------------
jerrystan's Profile: http://www.excelforum.com/member.php...o&userid=28573
View this thread: http://www.excelforum.com/showthread...hreadid=494190