CreateBackup Property

Applies To

Workbook Object.

Description

True if a backup will be created when this file is saved. Read-only.

Example

This example displays a message if a backup is created when the active workbook is saved.

If ActiveWorkbook.CreateBackup = True Then
    MsgBox "Remember, there is a backup copy of this workbook"
End If