Workbook.Saved Property

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

Syntax

expression.Saved

expression   A variable that represents a Workbook object.

Remarks

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.

Example

This example displays a message if the active workbook contains unsaved changes.

  If Not ActiveWorkbook.Saved Then
    MsgBox "This workbook contains unsaved changes."
End If

See Also

• Workbook Object
• Workbook Object Members
• Save Method
• SaveCopyAs Method