Excel VBA - Attach toolbar to template

[tbener]

Hi.

I have created a workbook with some source which i would like to oprate as a template.
I want a toolbar to be attched to the template and:
1. will be displayed only when a workbook based on this template opened.
2. the buttons stay attached to the template (they "follow" the last workbook i open )

Thanks.

[BrianB]

Try manually Tools/Customize then Attach.

[opus]

If you have code to "make" this tolbar, put it in the Workbook_auto_open Event (not sue of the correct name).
To hide it, you have to use code inthe Close_workbook event.

Watch it, if you use several workbooks having these codelines (the first to close would hide the toolbar).