| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Starting Auto_Close macro based on an IF statement | Excel Discussion (Misc queries) | |||
Threaded Mode
