如果能显示数据透视表字段列表,则为 True(默认)。Boolean 类型,可读写。
expression.ShowPivotTableFieldList
expression 必需。该表达式返回“应用于”列表中的对象之一。
在本示例中,Microsoft Excel 判断是否能显示数据透视表字段列表,并通知用户。
Sub UseShowPivotTableFieldList()
Dim wkbOne As Workbook
Set wkbOne = Application.ActiveWorkbook
'Determine PivotTable field list setting.
If wkbOne.ShowPivotTableFieldList = True Then
MsgBox "The PivotTable field list can be viewed."
Else
MsgBox "The PivotTable field list cannot be viewed."
End If
End Sub