Pointing to correct macro path using excel custom toolbar - HELP!

[COR]

I have created an excel 2000 template (.xlt) containing a number o
macros. When I open copies of this template on various pcs, the macro
function correctly, except I cannot successfully run the macros usin
the custom toolbar I created, because (I think) within the toolbar th
paths to the macros are pointed to the original location on my pc. An
advice on how I can resolve this would be gratefully received

 

[Dave Peterson]

Have you thought about building the toolbar when the file opens?

Or maybe separating the worksheet portion of the template from the code part of
the template. Put the code into a separate workbook and have the users open
that addin when they need to use the macros.

It might make things simpler if the code must change and the users have lots of
workbooks/worksheets already built.

Here's a link with a couple of ideas:
http://groups.google.com/[email protected]