_Application.ResetTipWizard Method

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.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub ResetTipWizard
'Usage
Dim instance As _Application

instance.ResetTipWizard()
void ResetTipWizard()

Examples

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

With Workbooks("BOOK1.XLS").RoutingSlip     If .Status = xlRoutingComplete Then         .ResetElse         MsgBox "Cannot reset routing; not yet complete"     End If End With

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace