영어로 읽기

다음을 통해 공유


Worksheet.PivotTableChangeSync Event (Excel)

Occurs after changes to a PivotTable.

Version Information

추가된 버전: Excel 2010

Syntax

.PivotTableChangeSync(Target )

A variable that represents a Worksheet object.

Parameters

Name

Required/Optional

Data Type

Description

Target

필수

PivotTable

The PivotTable that was changed.

Return Value

Nothing

Remarks

The PivotTableChangeEvent occurs during most changes to a PivotTable, so that you can write code to respond to user actions, such as clearing, grouping, or refreshing items in the PivotTable.

Example

The following code example displays a message box that shows the name of the PivotTable the user changed.

Private Sub Worksheet_PivotTableChangeSync(ByVal Target As PivotTable) 
 
With Target 
 MsgBox "You performed an operation in the following PivotTable: " & .Name 
End With 
 
End Sub

참고 항목

개념

Worksheet Object

Worksheet Object Members