RoutingSlip.Reset Method

  • Article
Excel Developer Reference

Resets the routing slip so that a new routing can be initiated with the same slip (using the same recipient list and delivery information). The routing must be completed before you use this method. Using this method at other times causes an error.

Syntax

expression.Reset

expression   A variable that represents a RoutingSlip object.

Return Value
Variant

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