VBA Events get disconnected after code crash

[Majjek]

Hello,

I'm busy with some events in VBA.

I've created an EventClass with 2 subs Connect and Disconnect to activate the Events.

There is 1 OnSaveDocument event present and it works perfect.

But when I'm working on other code, and during debugging it crashes, the Eventclass seems to get disconnected.

That means I have to reconnect to the EventClass again each time my code crashes.

How can I prevent this from happening?

Thanks in advance.

[bradeneuropeArthur · Accepted solution]

By creating an add-in with ie VB.net.

Regards,

[chandra.shekar.g]

@Majjek ,

To test crash, please share VBA code and make sure that files are non confidential.

Thanks and regards,

[Majjek]

Thanks for the answers guys.

I knew this would be one of the answers I'd receive .

Because I'm not very familiar with VB.Net and VS, I thought it would took me some time before I could create an add-in with events.

But a little search on the forums showed me that it wasn't that hard.

[bradeneuropeArthur]

Fully agree with that...