First, I would think that if you're sharing a macro, then instead of creating a
template file, you'd create an addin.

I usually use template files when there's stuff on worksheets that I need to
share and the macros in the template file are specific to that workbook.

If it's a bunch of general procedures with nothing that requires user to update
worksheets in the workbook, then I'd use an addin.

Then I can distribute the addin either emails (individual copies to each user)
or put it on a network drive (one addin--multiple users). The users can install
it via tools|Addins.

If you want to explore this idea...

If you want to add an option 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)


nenzax wrote:

HI all,

I have a Excel template in which i have created a toolbar button and
assigned it a macro and saved it as template.

But when i create a new file based on the template and click on the
toolbar button the following message pops up.

"The macroc:\temp\sheets\Templatename1.xls!RemoveTitles cannot be
found"

Thanks
Nen

--

Dave Peterson