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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Larry Haydn

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

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

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