View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default don't allow excel event kill

If you suspect that your events have become turned off, you can always go
into the VBA editor and execute this line...

Application.EnableEvents = True

in the Immediate window to restore the event processing. If you are using
this in your code, you should structure things like this...

Sub DoIt(...) ' or Function DoIt(...)
On Error GoTo MakeEverythingRight
Application.EnableEvents = False
'......
'...... <<Your code goes here
'......
Exit Sub ' or Exit Function <<== optional, depends on code
MakeEverythingRight:
Application.EnableEvents = True
End Sub ' or End Function

Rick


"x taol" wrote in message
...
application.enableevents=false
the code can kill the event routine of all workbooks.

The anyone can kill xl event with that code of one line.
I want to live continually the event in the specific workbook only.
how to method?
excel guru !!,,, answer...help me..


*** Sent via Developersdex http://www.developersdex.com ***