Status Property
Indicates the status of the routing slip. Read-only XlRoutingSlipStatus.
XlRoutingSlipStatus can be one of these XlRoutingSlipStatus constants. |
xlNotYetRouted |
xlRoutingComplete |
xlRoutingInProgress |
expression.Status
expression Required. An expression that returns one of the objects in the Applies To list.
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