Share via


Workbook.ShowPivotTableFieldList Property

Excel Developer Reference

True (default) if the PivotTable field list can be shown. Read/write Boolean.

Syntax

expression.ShowPivotTableFieldList

expression   A variable that represents a Workbook object.

Example

In this example, Microsoft Excel determines if the PivotTable field list can be shown and notifies the user.

Visual Basic for Applications
  Sub UseShowPivotTableFieldList()
Dim wkbOne As Workbook

Set wkbOne = Application.ActiveWorkbook

'Determine PivotTable field list setting.
If wkbOne.<strong class="bterm">ShowPivotTableFieldList</strong> = True Then
    MsgBox "The PivotTable field list can be viewed."
Else
    MsgBox "The PivotTable field list cannot be viewed."
End If

End Sub

See Also