Status Property

Applies To

RoutingSlip object.

Description

Indicates the status of the routing slip. Can be one of the following XlRoutingSlipStatus constants: xlNotYetRouted, xlRoutingInProgress, or xlRoutingComplete. Read-only Long.

Example

This example resets the routing slip for Book1.xls if routing has been completed.

With Workbooks("Book1.xls").RoutingSlip
    If .Status = xlRoutingComplete Then
        .Reset
    Else
        MsgBox "Cannot reset routing; not yet complete."
    End If
End With