Workbook.Saved (Excel)

True if no changes have been made to the specified workbook since it was last saved.

If a workbook has never been saved, its Path property returns an empty string (""). You can set this property to True if you want to close a modified workbook without either saving it or being prompted to save it.


ActiveWorkbook.Saved = True