Share via

Time Property

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.Time

expression   Required. An expression that returns an AutoRecover object.

Remarks

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

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

Example

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

  Sub SetTimeValue()

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

End Sub