LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get Save Prompt when closing workbook immediately after savingworkbook dbKemp Excel Programming 2 January 18th 08 09:11 PM
no updates prompt at opening and save changes at closing Shariq Excel Discussion (Misc queries) 3 January 10th 07 01:08 AM
why it never prompt to save after closing lightstraight Setting up and Configuration of Excel 1 August 21st 06 12:05 PM
No save prompt when closing workbook budfrog130 Excel Discussion (Misc queries) 0 December 6th 05 01:54 PM
Prompt to save on closing Jake Excel Discussion (Misc queries) 7 October 4th 05 12:05 AM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"