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?