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.

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


Show: