ADD.TOOLBAR macro

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

Return to index