WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate

A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.

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

Syntax

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

Parameters

  • Sh
    Type: System.Object

    The worksheet that contains the PivotTable.

  • Cancel
    Type: System.Boolean

    false when the event occurs. If the event procedure sets this argument to true, the changes are not committed against the OLAP data source of the PivotTable.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace