template toolbars

[D.riggins]

A custom toolbar that has buttons that execute VBA subroutines in an Excel
2003 template does not function properly when a new file is created from the
template. 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]

Instead of having the template create the toolbar, you may want to create a
single addin that contains the macros--and the code that creates the toolbar
(and destroys the toolbar).

That way, you'll have one file to update if the macros change. You won't have
to change the template file and every file that was created from that template.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm