Worksheet Events Not Working Consistenly

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
#

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You need to select the code & use the button marked #, not type #

Apologies, please delete this version, I have re posted.

Don't duplicate the reply, simply use the Edit button