Share via


WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate

A Delegate type used to add an event handler for the SheetPivotTableBeforeDiscardChanges event. The SheetPivotTableBeforeDiscardChanges event occurs before changes to a PivotTable are discarded.

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

Syntax

'Declaration
<ComVisibleAttribute(False)> _
Public Delegate Sub WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler ( _
    Sh As Object, _
    TargetPivotTable As PivotTable, _
    ValueChangeStart As Integer, _
    ValueChangeEnd As Integer _
)
'Usage
Dim instance As New WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(AddressOf HandlerMethod)
[ComVisibleAttribute(false)]
public delegate void WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(
    Object Sh,
    PivotTable TargetPivotTable,
    int ValueChangeStart,
    int ValueChangeEnd
)

Parameters

  • Sh
    Type: System.Object

    The worksheet that contains the PivotTable.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace