ShowPivotTableFieldList Property [Excel 2003 VBA Language Reference]

  • Article

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

expression.ShowPivotTableFieldList

expression Required. An expression that returns one of the objects in the Applies To list.

Example

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

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

Applies to | Workbook Object