Application.EnableEvents

[DCPan]

If you accidentally disabled events due to an error in logic, how do you turn
it back on?

 

[Dave Peterson]

Go into the VBE
Hit ctrl-g (to see the immediate window)
type:
application.enableevents = true
and hit enter.

 

[Gord Dibben]

I keep these two handy on a Toolbar for when I'm working on event code and
screwing it up.

Sub enable_events()
Application.EnableEvents = True
End Sub

Sub disable_events()
Application.EnableEvents = False
End Sub


Gord Dibben MS Excel MVP

 

[ShaneDevenshire]

Hi,

In your finished code you should consider something like this

Sub myProcedure()
On Error GoTo ErrorHandler

'your code here

ErrorHandler:
Application.EnableEvents = True
End Sub