Autosave

L

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.
 
R

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
 
Top