gjvdkamp
Posts: 56
Joined: 2018-08-28
|
Hi, is there any way to distuinguish Excel shutdown from AddIn unload?
I have subscribed to both
MainAddin_AddinBeginShutdown
MainAddin_AddinFinalize
If I shutdown of Excel or disable the addin (through options) they both fire and I can't find anything different on the ExcelApp object to tell them apart.
Rgds GJ |
|
Andrei Smolin
Add-in Express team
Posts: 18825
Joined: 2006-05-11
|
Hello GJ,
Check https://www.add-in-express.com/creating-addins-blog/2011/12/05/excel-calculation-mode-event/. In the code of the sample add-in project you'll see how to intercept opening the File | Options dialog. I assume the AddinBeginShutdown will occur before the dialog is closed if you turn the add-in off using the COM Add-ins dialog.
BTW, you also need to intercept opening the COM Add-ins dialog by using any other way, say via the corresponding built-in command added to the Quick Access Toolbar.
Andrei Smolin
Add-in Express Team Leader |
|