DisplayToolbar Property

         Example         Applies To

True if the toolbar on the specified spreadsheet or PivotTable list is displayed. The default value is True. Read/write Boolean.

Remarks

Hiding the toolbar does not change the height of the PivotTable list, but it does cause a layout change. The width is unchanged unless the AutoFit property is True and the PivotTable list was sized wider than the necessary to accomodate the toolbar.