共用方式為


Workbook.CreateBackup Property (Excel)

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

Syntax

expression .CreateBackup

expression A variable that represents a Workbook object.

Example

This example displays a message if a backup file 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

請參閱

概念

Workbook Object

Workbook Object Members