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.

• TargetPivotTable
  Type: Microsoft.Office.Interop.Excel.PivotTable

  The PivotTable that contains the changes to discard.

• ValueChangeStart
  Type: System.Int32

  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
  Type: System.Int32

  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.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace