Custom toolbars in templates

[D Riggins]

I have created a custom toolbar in and Excel 2003 template. The toolbar has
buttons that execute VBA subroutines. The Toolbar seems to function properly
in the template, but when a new file is created from the template, the
buttons for the subroutines produce errors. It appears that the toolbar in
the new file is trying to execute the sub in the template. How do you make
sure custom toolbar buttons execute the VBA sub in the workbook created from
a template?

 

[royUK]

It's best to add the Toolbar using code. This example creates a Floating
Toolbar


+-------------------------------------------------------------------+
|Filename: ToolBarExample.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=38|
+-------------------------------------------------------------------+

 

[Spreadsheet Solutions]

Well;

You must be sure to refer to right workbook.
The worbook that you want to have the code executed on, must be the active
workbook.

So, set good reference to your workbooks, or work with statements like
Workbooks(XYZ).Activate

 

[Dave Peterson]

Check your other post, too.

I have created a custom toolbar in and Excel 2003 template. The toolbar has
buttons that execute VBA subroutines. The Toolbar seems to function properly
in the template, but when a new file is created from the template, the
buttons for the subroutines produce errors. It appears that the toolbar in
the new file is trying to execute the sub in the template. How do you make
sure custom toolbar buttons execute the VBA sub in the workbook created from
a template?