Routed Property

Microsoft Excel Visual Basic

Routed Property

       

True if the workbook has been routed to the next recipient. False if the workbook needs to be routed. Read-only Boolean.

Remarks

If the workbook wasn't routed to the current recipient, this property is always False (for example, if the document has no routing slip, or if a routing slip was just created).

Example

This example sends the workbook to the next recipient.

If ActiveWorkbook.HasRoutingSlip And _
    Not ActiveWorkbook.Routed Then
        ActiveWorkbook.Route
End If