View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!