Share via

RoutingSlip.Status Property

  • Article
Excel Developer Reference

Indicates the status of the routing slip. Read-only XlRoutingSlipStatus.

Syntax

expression.Status

expression   A variable that represents a RoutingSlip object.

Remarks

XlRoutingSlipStatus can be one of these XlRoutingSlipStatus constants.
xlNotYetRouted
xlRoutingComplete
xlRoutingInProgress

Example

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

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

See Also