B
baobob
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.
***
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.
***