Is there a better alternative to using Workbook_Deactivate()?

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
535
I have a report that won't run when a user has certain Excel Add-Ins installed, and the solution seems to be to turn the add-in off automatically when the workbook opens and turn it back on again when the workbook closes. I got the first half of this problem to work perfectly, but it appears that when I use Private Sub Workbook_Deactivate() the code gets skipped entirely if they quit out of Excel instead of closing the workbook. Is there a different code I could use that would run before quitting?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Larry Haydn

Board Regular
Joined
Jul 18, 2019
Messages
96
Office Version
  1. 365
Platform
  1. Windows
Instead of Workbook_Deactivate(), try:
Workbook_BeforeClose()
 

Watch MrExcel Video

Forum statistics

Threads
1,122,364
Messages
5,595,722
Members
414,013
Latest member
tnobbs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top