Custom Toolbar showing in any and all workbooks opened

[Jack_Feeman]

Created a custom toolbar for a template using the customize command. Assign
each button in the custom toolbar to a macro. Recorded the macros careful to
assign them only to current Workbook. Now no matter what document I open the
custom toolbar is opened also. When I goto Tools>Macro>Macros there are not
maros listed for any of the choices (This workbook, All Open workbooks,etc).
Is there a simple way short of writing VBA to restrict this toolbar to
opening only in the document for which it was created?

Thanks

 

[Zone]

Jack, open Excel and open the workbook for which the toolbar was
created. Right-click on the toolbar and select customize. On the
Toolbars tab, click Attach. Select the toolbar from the list. Click
Copy. Click OK. This attaches the toolbar to the worksheet. Alt-F11
to view the code editor. If you do not have a standard module, click
Insert, then Module. In the standard module, put
Sub Autpen()
Commandbars("NameOfToolbarHere").Visible=True
End Sub
Sub Auto_Close()
Commandbars("NameOfToolbarHere").Delete
End Sub
Of course, put the name of your toolbar in place of NameOfToolbarHere,
leaving the quotes in. Now, when you close Excel, the toolbar will be
deleted from the toolbar collection. When you open the file again, the
toolbar will be shown. James