Distuinguish Excel Shutdown form Addin Unload?

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

Distuinguish Excel Shutdown form Addin Unload?
 
gjvdkamp




Posts: 39
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
Posted 05 May, 2020 06:24:45 Top
Andrei Smolin


Add-in Express team


Posts: 17438
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.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 May, 2020 07:35:00 Top