RoutingSlip.Status Property

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`

status status property Understanding Scope and Visibility

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