共用方式為


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

請參閱

概念

PivotTable Object

PivotTable Object Members