worksheet change event > error events disabled

[Peter]

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

 

[Bob Phillips]

Peter,

Mine is similar, just a little different

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

.....

Errorhandler:
Application.EnableEvents = True

End sub

and I don't get your problem.

Why does deleting a row generate an error?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peter]

Thanks for your help, Bob.

A good nights rest, however, helped me solve my problem even before I
checked for any replies.

Peter