Syntax

expression.EnableFieldDialog

expression A variable that represents a PivotTable object.

Remarks

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

Example

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

Visual Basic for Applications 
Worksheets(1).PivotTables("Pivot1") _ .PivotFields("Year").EnableFieldDialog = False
disable pivot table field dialog box enable field dialog Enable Field Dialog Property enablefield EnableFieldDialog enablefielddialog property make dialog box available user double-clicks

See also: