WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler Delegate

Definition

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

public delegate void WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(System::Object ^ Sh, PivotTable ^ TargetPivotTable, int ValueChangeStart, int ValueChangeEnd);
[System.Runtime.InteropServices.ComVisible(false)]
public delegate void WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(object Sh, PivotTable TargetPivotTable, int ValueChangeStart, int ValueChangeEnd);
Public Delegate Sub WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler(Sh As Object, TargetPivotTable As PivotTable, ValueChangeStart As Integer, ValueChangeEnd As Integer)
Parameters
Sh

The worksheet that contains the PivotTable.

TargetPivotTable

The PivotTable that contains the changes to discard.

ValueChangeStart

The 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

The 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.

Inheritance
WorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandlerWorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandlerWorkbookEvents_SheetPivotTableBeforeDiscardChangesEventHandler
Attributes

Applies to