PivotTableChange Event

Microsoft Office Web Components Object Model

Show All

PivotTableChange Event

       

Occurs whenever a PivotTable list field, field set, or total is added or deleted.

Private Sub PivotTable_PivotTableChange(Reason As PivotTableReasonEnum)

Reason   Specifies how the PivotTable list changed. Can be one of the PivotTableReasonEnum constants.

plPivotTableReasonTotalAdded
plPivotTableReasonFieldSetAdded
plPivotTableReasonFieldAdded

Remarks

For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript.