EnableWizard Property

Microsoft Excel Visual Basic

EnableWizard Property

       

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