VBA / Excel: Code to check if events are enabled.

[dbmathis]

Hi all,

Maybe this is not possible, but how would I use VBA code to check if application.enableevents is = true or false?

Thanks.

 

[Norie]

Something like this perhaps?

Sub AreEventsEnabled()
    MsgBox "It is " & Application.EnableEvents & " that events are enabled."
End Sub

 

[seenfresh]

How about:


If Application.EnableEvents = False Then Msgbox "FALSE"
Else: Msgbox "TRUE"

http://www.cpearson.com/excel/events.htm is a good site for more info on Enabling Events

 

[dbmathis]

Duh, sorry to waste everyones time. That should have been obvious.

Thanks for the help.

 

[davidam]

Also use the immediate window (Ctrl G):
?Application.EnableEvents