Auto_Close

  • Thread starter Thread starter Luc Benninger
  • Start date Start date
L

Luc Benninger

Hi,
I got an Excel XP add-in that implements the method "auto_close" for
cleaning some things up when excel is closed.
Problem: If I got an unsaved workbook open and try to close the whole Excel
application (not just the workbook) using File / Exit or the X in the upper
right corner I get a "Do you want to save..." messagebox. If I change now my
mind and choose "Cancel" for canceling the excel shutdown, the Auto_Close
method has already executed (which it should not as the user can continue to
work...).
Does anyone have a hint on how to deal with this buggy behavier?
thanks, Luc
 
Have your auto_close code handle the closing of workbooks that are still
open. Then you can prompt the user and stop processing if appropriate.
 
Many thanks!

Tom Ogilvy said:
Have your auto_close code handle the closing of workbooks that are still
open. Then you can prompt the user and stop processing if appropriate.

--
Regards,
Tom Ogilvy

now continue
Click to expand...
 
Back
Top