Auto_Close
 

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

Auto_Close
 

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

"Luc Benninger" <s9271256(at)gmx.ch wrote in message
...
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

Auto_Close
 

Many thanks!

"Tom Ogilvy" wrote in message
...
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

"Luc Benninger" <s9271256(at)gmx.ch wrote in message
...
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