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