ADD.TOOLBAR

Macro Sheets Only

Creates a new toolbar with the specified buttons.

Syntax

ADD.TOOLBAR(bar_name, tool_ref)

Bar_name is a text string identifying the toolbar you want to create.

Tool_ref is either a number specifying a built-in button or a reference to an area on the macro sheet that defines a custom button or set of buttons (or an array containing this information).

For a complete description of tool_ref, see ADD.TOOL.

Remarks

If you create a toolbar without buttons, use ADD.TOOL to add them. Use SHOW.TOOLBAR to display the toolbar.

Example

The following macro formula creates Toolbar9 with one button in it. The cell range B7:I7 contains tool_ref.


ADD.TOOLBAR("Toolbar9", B7:I7)

Related Functions

ADD.TOOL Adds a button to a toolbar

DELETE.TOOL Deletes a button from a toolbar

DELETE.TOOLBAR Deletes custom toolbars

RESET.TOOLBAR Resets a built-in toolbar to its default initial setting

SHOW.TOOLBAR Hides or displays a toolbar

List of Customizing Functions