I
I
Ivan Pavlov2016-10-27 15:20:51
Visual Basic
Ivan Pavlov, 2016-10-27 15:20:51

How can I disable some AddIns in Excel when I close the application?

Hello! There is a VSTO tab that works with some set of self-written AddIns. Before running macros, this tab connects AddIn and runs the macro itself. Of course, after its work, AddIn does not disable itself. All AddIns are located on a network drive, which causes a very long load time when starting Excel. It is inconvenient to store them locally on a large number of computers for well-known reasons - updates are frequent, and no one wants to manually reinstall them.
There were attempts to catch Workbook_BeforeClose and disable the necessary AddIns in it, but it did not help - the code works, but when Excel is reopened, all AddIns still remain enabled.
They also caught Ribbon_Close, which also did not work. Auto_Close in some of the AddIns doesn't help either.
Actually a few questions:
1. What is the reason for this behavior of Excel? Maybe it saves the enable state of AddIns until Workbook_BeforeClose, Ribbon_Close and Auto_Close are executed?
2. Is it really necessary to lay the logic of deleting yourself after work in each AddIns?
3. Are there other ways to speed up Excel loading if AddIns are located on a network drive?
4. Maybe there are automatic ways to update AddIns from a network drive, for example, as in WPF?
5. And of course the main question - how can I disable some AddIns in Excel when the application is closed?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question