Do you wish to save prompt
I am no longer prompted to save when I am closing out of excel - even though
I have made changes to the file. Auto-save is still set, however, if I exit before saving excel will just close. I have search through tools/options, but am seeing nothing. Thanks! |
Do you wish to save prompt
Look for any macro that has:
ActiveWorkbook.Saved = True in it. Excel wil not prompt you if it THINKS the file has already been saved. For example, puttting the following in ThisWorkbook code will avoid the prompt entirely during File Quit Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.Saved = True End Sub -- Gary''s Student "Kelley" wrote: I am no longer prompted to save when I am closing out of excel - even though I have made changes to the file. Auto-save is still set, however, if I exit before saving excel will just close. I have search through tools/options, but am seeing nothing. Thanks! |
All times are GMT +1. The time now is 07:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com