Is there a better alternative to using Workbook_Deactivate()?

[9tanstaafl9]

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?

 

[Larry Haydn]

Instead of Workbook_Deactivate(), try:
Workbook_BeforeClose()