EnableWizard Property [Excel 2003 VBA Language Reference]

  • Article

True if the PivotTable Wizard is available. The default value is True. Read/write Boolean.

Remarks

When this property is set, the field wells aren't displayed on the worksheet.

Example

This example disables the PivotTable Wizard for the first PivotTable report on worksheet one.

Worksheets(1).PivotTables("Pivot1").EnableWizard = False

Applies to | PivotTable Object