Skip to content

Latest commit

 

History

History
39 lines (24 loc) · 817 Bytes

Excel.Workbook.CreateBackup.md

File metadata and controls

39 lines (24 loc) · 817 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Workbook.CreateBackup property (Excel)
vbaxl10.chm199093
vbaxl10.chm199093
Excel.Workbook.CreateBackup
33f05bf8-00ef-81f4-c083-30326f019cd4
05/29/2019
medium

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

[!includeSupport and feedback]