Occurs after a PivotTable report connection has been opened.
expression.WorkbookPivotTableOpenConnection (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 opened. This example assumes that you have declared an object of type Workbook with events in a class module.
Private Sub ConnectionApp_WorkbookPivotTableOpenConnection(ByVal wbOne As Workbook, Target As PivotTable) MsgBox "The PivotTable connection has been opened." End Sub