A
andreashermle
Dear Experts:
Whenever I run this macro a dialog field pops up asking me to enter a
macro name. Why is this so?
Sub Worksheet_Change(ByVal Target As Excel.Range)
If Len(Range("E4")) < 32 And Range("E4") <> "" Then
ActiveSheet.Name = Range("E4").Value
End If
End Sub
Whenever I run this macro a dialog field pops up asking me to enter a
macro name. Why is this so?
Sub Worksheet_Change(ByVal Target As Excel.Range)
If Len(Range("E4")) < 32 And Range("E4") <> "" Then
ActiveSheet.Name = Range("E4").Value
End If
End Sub