To attach a toolbar select it and click the Copy button

When a toolbar in the Toolbars in Workbook list (right side of the dialog box) is selected, the Copy button changes to a Delete button. You can click the Delete button to remove the selected toolbar from the workbook.

Figure 19-7:

The Attach Toolbars dialog box lets you attach one or more toolbars to a workbook.

Figure 19-7:

The Attach Toolbars dialog box lets you attach one or more toolbars to a workbook.

A toolbar that's attached to a workbook appears automatically when the workbook is opened, and that toolbar is then saved in the user's XLB file when Excel closes down. If the user's workspace already has a toolbar by the same name, however, the toolbar attached to the workbook does not replace the existing one.

JUNG/

JUNG/

The toolbar that's stored in the workbook is an exact copy of the toolbar at the time you attach it. If you modify the toolbar after attaching it, the changed version is not stored in the workbook automatically. You must manually remove the old toolbar and then attach the new one.

0 0

Post a comment