How can I create a Global Template with custom Toolbar that can be shared by
other users.
Thanks,
rcruz

I use something like this to create toolbars on the fly.

http://groups.google.com/groups?thre...5B41%40msn.com
If that link doesn't work, try this one:
http://www.google.ca/groups?threadm=...5B41%40msn.com

If you put the code in the workbook and save it as a template, then you'll see
the toolbars when you start the new workbook.

But I think I'd do something slightly different.

I'd put all the code (including creating/deleting the toolbars) into another
workbook. Save this workbook as an addin (.xla).

Then save your template with just the data in it.

Have the users open the addin (but provide a button that creates a new workbook
based on your template).

By separating the code from the data, you may find that you have fewer things to
catch when something changes.

(If the template changes, just update the template. If the code changes, update
the addin. You may be able to update problems in the code without causing any
problems for workbooks based on the existing template.)

jrcruzr wrote:

How can I create a Global Template with custom Toolbar that can be shared by
other users.
Thanks,
rcruz

--

Dave Peterson