Application.WorkbookPivotTableCloseConnection Event

  • Article
Excel Developer Reference

Occurs after a PivotTable report connection has been closed.

Syntax

expression.WorkbookPivotTableCloseConnection(Wb, Target)

expression   A variable that represents an Application object.

Parameters

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

Return Value
Nothing

Example

This example displays a message stating that the PivotTable report's connection to its source has been closed. This example assumes you have declared an object of type Workbook with events in a class module.

Visual Basic for Applications 
  Private Sub ConnectionApp_WorkbookPivotTableCloseConnection(ByVal wbOne As Workbook, Target As PivotTable)

MsgBox "The PivotTable connection has been closed."



End Sub

See Also