PivotTableChange Event
Occurs whenever a PivotTable list field, field set, or total is added or deleted.
Private Sub PivotTable_PivotTableChange(Reason As PivotTableReasonEnum)
PivotTableReasonEnum
| plPivotTableReasonTotalAdded |
| plPivotTableReasonFieldSetAdded |
| plPivotTableReasonFieldAdded |
Remarks
For information about using events with VBScript, see Declaring and Using Event Procedures in VBScript .
Applies to | PivotTable Object