View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
D Riggins D Riggins is offline
external usenet poster
 
Posts: 7
Default Custom toolbars in templates

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?