EnableFieldDialog Property

Microsoft Excel Visual Basic

EnableFieldDialog Property

       

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 report sets it for all fields in thatreport.

Example

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

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