View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How can you turn off "Do you want to save changes you made to ..."

Hi,

To generate this prompt something is changing in the workbook even if you
don't recognise it as being a deliberate change but you could do this. Alt
+F11 to open VB editor. Double click 'This Workbook' and paste this in on the
right

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub

But be aware you won't get the prompt to save if you have made changes you
want to keep and could end up losing them. My view FWIW, I wouldn't do it but
perhaps that's just my instinct to protect data.

Mike

"Cereal Killer" wrote:

How can you turn off "Do you want to save changes you made to 'filename'.xls"
when closing a file, in Excel 2003, if you made no changes. Excel used to
recognize that no changes were made.