Syntax
Private Sub Worksheet_PivotTableBeforeCommitChanges(ByVal TargetPivotTable As PivotTable, ByVal ValueChangeStart
As Long, ByVal ValueChangeEnd As Long, Cancel As Boolean)
Enter
Code
End Sub
This event occurs before changes are
committed against the OLAP data source for a PivotTable.
Required Parameters
TargetPivotTable
The PivotTable that contains the changes to
commit.
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.
Cancel
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.
