EnableAutoRecover Property

Microsoft Excel Visual Basic

EnableAutoRecover Property

       

Saves changed files, of all formats, on a timed interval. If Microsoft Excel fails, the system fails, or if the system is improperly shut down (not allowing Excel to save the changed files), the backed up files are opened and the user has an opportunity to save changes that otherwise would have been lost. When the user restarts Excel, a document recovery window opens, giving the user an option to recover the files they were working on. Setting this property to True (default) enables this feature. Read/write Boolean.

expression.EnableAutoRecover

expression   Required. An expression that returns a Workbook object.

Example

The following example checks the setting of the AutoRecover feature and if not enabled, Excel enables it and then notifies the user.

Sub UseAutoRecover()

    ' Check to see if the feature is enabled, if not, enable it.
    If ActiveWorkbook.EnableAutoRecover = False Then
        ActiveWorkbook.EnableAutoRecover = True
        MsgBox "The AutoRecover feature has been enabled."
    Else
        MsgBox "The AutoRecover feature is already enabled."
    End If

End Sub