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?

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


--
Best regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (the country were they live some 18 feet beyond sea level)
--
E: (E-Mail Removed)
W: www.spreadsheetsolutions.nl
--


"D Riggins" <(E-Mail Removed)> wrote in message
newsC0D23C9-657B-4821-B0E5-(E-Mail Removed)...
>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?

Check your other post, too.

D Riggins wrote:
>
> 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?

--

Dave Peterson