WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler Delegate
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
A Delegate type used to add an event handler for the SheetPivotTableBeforeAllocateChanges event. The SheetPivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.
public delegate void WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler(System::Object ^ Sh, PivotTable ^ TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, [Runtime::InteropServices::Out] bool % Cancel);[System.Runtime.InteropServices.ComVisible(false)]
public delegate void WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler(object Sh, PivotTable TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, out bool Cancel);Public Delegate Sub WorkbookEvents_SheetPivotTableBeforeAllocateChangesEventHandler(Sh As Object, TargetPivotTable As PivotTable, ValueChangeStart As Integer, ValueChangeEnd As Integer, ByRef Cancel As Boolean)Parameters
- Sh
- Object
The worksheet that contains the PivotTable.
- TargetPivotTable
- PivotTable
The PivotTable that contains the changes to apply.
- ValueChangeStart
- Int32
The index to the first change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
- ValueChangeEnd
- Int32
The index to the last change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
- Cancel
- Boolean
false when the event occurs. If the event procedure sets this argument to true, the changes are not applied to the PivotTable and all edits are lost.
- Attributes