Skip to main content

Application.WorkbookPivotTableCloseConnection event

Occurs after a PivotTable report connection has been closed.


expression.WorkbookPivotTableCloseConnection (WbTarget)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
Wb Required Workbook The selected workbook.
Target Required PivotTable The selected PivotTable report.

Return value



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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>