Autosave

[Liz]

When a workbook is closed automatically appears the
message "Do you want to save the changes?" How can I avoid
this message and always answer "No"?
Thank you.
Liz.

 

[Ron de Bruin]

Hi Liz

In the BeforeClose event use this

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

Or if you close the file with code

ThisWorkbook.Close False