View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_21_] Peter[_21_] is offline
external usenet poster
 
Posts: 35
Default worksheet change event error events disabled

Hi there

I noticed that occurring errors disable the triggering of eventprocedures.
I thought I'd deal with this by adding an error handler to the code in this
mannor:

sub test()
Application.EnableEvents = False
On error goto Errorhandler

.....
Application.EnableEvents = True
Exit Sub
Errorhandler:
Application.EnableEvents = True

End sub

Deleting an entire row forinstance would cause an error, but adding this
errorhandling code causes excel not to inform me about the error, which is
logical.

However, the events are not re-enabled.

Does anyone have expirience with this ?

Greetings,
Peter