Occurs after a PivotTable report connection has been closed.
expression.WorkbookPivotTableCloseConnection (Wb, Target)
expression A variable that represents an Application object.
|Wb||Required||Workbook||The selected workbook.|
|Target||Required||PivotTable||The selected PivotTable report.|
This example displays a message stating that the PivotTable report's connection to its source has been closed. This example assumes that you have declared an object of type Workbook with events in a class module.
Private Sub ConnectionApp_WorkbookPivotTableCloseConnection(ByVal wbOne As Workbook, Target As PivotTable) MsgBox "The PivotTable connection has been closed." End Sub