Excel.PivotTable.EnableFieldDialog.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.EnableFieldDialog property (Excel)	vbaxl10.chm235107	vbaxl10.chm235107	Excel.PivotTable.EnableFieldDialog	4b6b4bc5-9b87-efa2-c6d1-4ab0c11f5966	05/08/2019	medium

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

[!includeSupport and feedback]