EnableWizard Property

Microsoft Excel Visual Basic

previous page next page

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
previous page start next page