Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Occurs after the sheet of the PivotTable report has been updated.
Private Subexpression**_SheetPivotTableUpdate**(ByVal Sh As Object, Target As PivotTable)
expression A variable which references an object of type Application or Workbook declared with events in a class module.
Sh Required. The selected sheet.
Target Required. The selected PivotTable report.
Example
This example displays a message stating that the sheet of the PivotTable report has been updated. This example assumes you have declared an object of type Application or Workbook with events in a class module.
Private Sub ConnectionApp_SheetPivotTableUpdate(ByVal shOne As Object, Target As PivotTable)
MsgBox "The SheetPivotTable connection has been updated."
End Sub
Applies to | Application Object | Workbook Object