_Application.ResetTipWizard Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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.

public:
 void ResetTipWizard();

public void ResetTipWizard ();

Public Sub ResetTipWizard ()

Examples

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

<span class="label">With Workbooks("BOOK1.XLS").RoutingSlip     If .Status = xlRoutingComplete Then         .</span>
<i>Reset</i>
<span class="label">Else         MsgBox "Cannot reset routing; not yet complete"     End If End With</span>

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

<span class="label">With Workbooks("BOOK1.XLS").RoutingSlip     If .Status = xlRoutingComplete Then         .</span>
<i>Reset</i>
<span class="label">Else         MsgBox "Cannot reset routing; not yet complete"     End If End With</span>

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

<span class="label">With Workbooks("BOOK1.XLS").RoutingSlip     If .Status = xlRoutingComplete Then         .</span>
<i>Reset</i>
<span class="label">Else         MsgBox "Cannot reset routing; not yet complete"     End If End With</span>