vba Sub Worksheet_Change not working

[EasyEd]

An Excel program hung up on me and wouldn't reload, so I rebooted my computer. But now the Excel VBA subroutine 'Private Sub Worksheet_Change(ByVal target As Range)' doesn't work (it worked fine before the hangup)! The sub doesn't run even if I copy and paste it into a new workbook; it never gets activated (if I insert a breakpoint it's never recognized). I'm concerned that my Excel program might be corrupted, but I'm hoping that something changed that I can reset.
Any thoughts on how I can correct this?

 

[Colin Legg]

In the Visual Basic Editor immediate window (CTRL+G), type in the following code and press enter:

application.EnableEvents=True

 

[Richard Schollar]

In the Immediate Window of the VBE (in the VBE, Ctrl+G to open it) type:

?Application.EnableEvents

If it returns False, this shows that events have been disabled. Renable them with the following command:

Application.EnableEvents = True

 

[pedie]

first try running this code

Sub i()
Application.EnableEvents = True
End Sub

 

[pedie]

first try running this code

Sub i()
Application.EnableEvents = True
End Sub

Sorry we all cross posted

 

[EasyEd]

Thank you, thank you! "application.EnableEvents=True" fixed it

 

[lazov]

Hi Richard,

I am in the same boat as EasyEd had been in. Slight difference is that I cannot get EnableEvents activated, not even applying your solution after checking the status with ?Application.EnableEvents method.
The strange is which conditions it happens with: I have a Worksheet_SelectionChange macro applied on the sheet. It triggers many public functions; in all of them I set EnableEvents = True before End. So I do in SelectionChange macro. And it works perfectly! But when I delete a value in a cell, and then change the selection, nothing happens: the deletion sets the EnableEvents to False... so after deletion the SelectionChange never works again.
Can I kindly ask for advice?
Additionally, WorkSheet_Change function does not work in this workbook, God knows the reason why. I figure it might be related to the issue with SelectionChange - or am I completely wrong?

Thank you, Laszlo