This documentation is archived and is not being maintained.

EnableWizard Property [Excel 2003 VBA Language Reference]

Office 2003

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


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


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

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

Applies to | PivotTable Object