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 ***