All,

I have been working with Worksheet_SelectionChange and Worksheet_Change events. They start of working and then they stop, sometimes after a de-bug and sometime after a change on the worksheet. If I save and close the workbook and open it again it is fine. Can anybody tell me what is happening and suggest a fix?

An example of my code...

#
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error Goto Error Handler

NmRng = Target.Name.Name
Application.EnableEvents = False

If Left(NmRng, 3) = "INP" Then
NmVal = Target.Value
NewVal = InputBox("Enter New Value", "Updtate Parameter)
End If

ErrorHandler:
Application.EnableEvents = True
End Sub
#