Auto_Close

[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

 

[Tom Ogilvy]

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.

 

[Luc Benninger]

Many thanks!

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