Status Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | RoutingSlip Object