Workbook.ShowPivotTableFieldList Property

  • Article
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