Add-in Express causing performance issue with VBA code

Add-in Express™ Support Service
That's what is more important than anything else

Add-in Express causing performance issue with VBA code
 
Amit B




Posts: 21
Joined: 2013-09-13
Thanks Andrei
This is a reasonable explanation.

But putting that button to enable/disable events may not be good from business perspective because users have to remember this every time before running the macro having problems. Moreover, there is no clear way for users to identify that their code has performance problem due to addin.

There are 100s of users and we can't train them for doing this.

We will see what else we can do.
Posted 28 Feb, 2017 11:34:51 Top
Niels Ziegler




Posts: 49
Joined: 2017-02-03
If Application.EnableEvents = false does help, maybe it would be possible to react to some sort of "BeforeVBAExecuting" event and have the add-in disable these events, and later enable them again?

Though there might be cases, where the user actually wanted the application events activated.
Posted 01 Mar, 2017 04:49:46 Top
Andrei Smolin


Add-in Express team


Posts: 14137
Joined: 2006-05-11
Hello Amit,

Thank you Niels!

I think there's no solution to this issue unless you modify the VBA code.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 01 Mar, 2017 04:56:57 Top