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. *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can just opening & closing a workbook prompt the Save?dialog?
P.S. I spoke too soon. The dialog has come back, and it still appears
every time I run the macro, even running it manually, and even executing nothing except simply closing again. Thanks. *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can just opening & closing a workbook prompt the Save?dialog?
P.P.S. I think I spoke even too sooner.
I don't think it has to do with the macro at all. The macro is Sub Auto_Open, so it executes automatically on load. I changed its name and don't run the macro at all any more. On loading the workbook then File / Close, I get the Save dialog. So is there something in the sheet itself that somehow dynamically changes upon loading? Answer: There may be. There is a formula in cell A1. I gotta debug it. Guess y'all can ignore this thread 'til I find out how the hell I'm shooting myself in the foot. *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can just opening & closing a workbook prompt the Save?dialog?
Aaagggghh!
My fault. I commented out my formula and that stopped the Save dialog. So it's programmer recreational drug use--again. *** But do I have a suspicion that Excel 2002 flags the Save condition differently than previous versions? Because I think I've used that formula for some years without incident. *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can just opening & closing a workbook prompt the Save?dialog?
On 26 Maj, 21:25, wrote:
P.P.S. I think I spoke even too sooner. I don't think it has to do with the macro at all. The macro is Sub Auto_Open, so it executes automatically on load. I changed its name and don't run the macro at all any more. On loading the workbook then File / Close, I get the Save dialog. So is there something in the sheet itself that somehow dynamically changes upon loading? Answer: There may be. There is a formula in cell A1. I gotta debug it. Guess y'all can ignore this thread 'til I find out how the hell I'm shooting myself in the foot. *** Hi If the value in the formula in A1 changes, then excel will always prompt to save the workbook. To avoid this, you can use a workbook_beforeClose event like below: Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Saved = True End Sub Regards, Per |
Reply |
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) |