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.ObjectThe worksheet that contains the PivotTable.
TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTableThe PivotTable that contains the changes to discard.
ValueChangeStart
Type: System.Int32The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
ValueChangeEnd
Type: System.Int32The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.