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

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



DCPan wrote:

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

--

Dave Peterson

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

On Fri, 17 Oct 2008 14:18:01 -0700, DCPan
wrote:

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

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


--
Thanks,
Shane Devenshire


"DCPan" wrote:

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