Time Property
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

AutoRecover.Time Property

Office 2007
Sets or returns the time interval for the AutoRecover object. Permissible values are integers from 1 to 120 minutes. The default value is 10 minutes. Read/write Long.



expression   A variable that represents an AutoRecover object.


Entering a decimal value will round to the nearest whole number. For example, entering a value of 5.5 is the equivalent of 6.

If time values outside the valid range are entered, Microsoft Excel will revert to the previous time value used.


The following example sets the AutoRecover time interval to 5 minutes and notifies the user.

Visual Basic for Applications
Sub SetTimeValue()

    Application.AutoRecover.Time = 5
    MsgBox "The AutoRecover time interval is set at " & _
        Application.AutoRecover.Time & " minutes."

End Sub

© 2016 Microsoft