DisplayToolbar Property

Microsoft Office Web Components Visual Basic

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

expression.DisplayToolbar

expression    Required. An expression that returns one of the objects in the Applies To list.

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 accommodate the toolbar.

Example

This example hides the spreadsheet’s toolbar.

Spreadsheet1.DisplayToolbar = False