EnableFieldDialog Property

Applies To

PivotTable object.

Description

True if the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. The default value is True. Read/write Boolean.

Remarks

Setting this property for a PivotTable sets it for all fields in that PivotTable.

Example

This example disables the PivotTable Field dialog box for the Year field.

Worksheets(1).PivotTables("Pivot1") _
    .PivotFields("Year").EnableFieldDialog = False