Prompt to enter a macro name?
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
|