Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can just opening & closing a workbook prompt the Save? dialog?
I have an Excel 2002 autoexec workbook which starts automatically when
Excel launches, sets some defaults, then closes its own workbook again. It neither reads nor writes to the worksheet, or does anything else to change the workbook in any way that would prompt the "Save your changes?" dialog on exit. It just sets some Tools / Options defaults and exits. It's run for years without incident. But recently I tweaked it and somehow got it into a state in which the Save dialog was appearing on close. To debug it, I moved it out of \XLSTART so that I could load it manually. I commented the code down so that ALL THE MACRO DID was close its own workbook without doing anything else. The Save dialog STILL appeared. So, after a couple of days of pulling my hair out, I threw in the towel and saved the workbook as it requested, and the dialog no longer appears. Anyone have a notion of what was happening? Thanks. *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Save Prompt when closing workbook immediately after savingworkbook | Excel Programming | |||
no updates prompt at opening and save changes at closing | Excel Discussion (Misc queries) | |||
why it never prompt to save after closing | Setting up and Configuration of Excel | |||
No save prompt when closing workbook | Excel Discussion (Misc queries) | |||
Prompt to save on closing | Excel Discussion (Misc queries) |