Status Property

Applies To

RoutingSlip Object.

Description

Indicates the status of the routing slip (one of xlNotYetRouted, xlRoutingInProgress, or xlRoutingComplete). Read-only.

Example

This example resets the routing slip for BOOK1.XLS if routing is complete.

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