Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Save Changes Prompt

How do I set Excel to prompt me to save changes when closing file? For some
reason, all of a sudden, when I make changes to a file and close it without
manually saving, I don't get asked if I want to save the changes anymore.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Excel Save Changes Prompt

Check your macros:

If DisplayAlerts is set to false, then the allert will not be issued
If ThisWorkbook.Saved is set to true, then Excel will think the save has
already happened.
--
Gary's Student
gsnu200703


"Billyg" wrote:

How do I set Excel to prompt me to save changes when closing file? For some
reason, all of a sudden, when I make changes to a file and close it without
manually saving, I don't get asked if I want to save the changes anymore.

Reply
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
save prompt for user exit, but no save prompt for batch import? lpj Excel Discussion (Misc queries) 1 February 25th 06 02:08 AM
Excel save as problem Gabor Excel Discussion (Misc queries) 3 February 23rd 06 04:35 PM
How to save sheets in new excel files, automatically? SuperDuck Excel Worksheet Functions 1 October 22nd 05 09:37 AM
AutoSave: How can I get it to save every 5 minutes & NO prompt? Valerie Excel Worksheet Functions 1 September 27th 05 10:53 PM
Save? prompt when closing Excel MC Excel Discussion (Misc queries) 4 March 12th 05 10:55 PM


All times are GMT +1. The time now is 02:00 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"