True if the toolbar on the specified spreadsheet, chartspace, or PivotTable list is displayed. The default value is True. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
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 accommodate the toolbar.
This example hides the spreadsheet's toolbar.
Spreadsheet1.DisplayToolbar = False