PivotTable.EnableFieldDialog Property (Excel)
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.
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.
Worksheets(1).PivotTables("Pivot1") _
.PivotFields("Year").EnableFieldDialog = False