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.

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Liz" wrote in message ...
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.