You can use Tools References in the VBA editor to set a reference to another
template and the code included there. But I don't recommend that arrangement
if you are likely to be distributing your code to other users. The full
pathname of the reference is hardcoded into your template, which means you
have no flexibility as to where the referenced template will be installed on
customer machines.

With ActiveX DLLs, once the DLL is registered, code can find it wherever the
DLL is located. The same does not apply to .dot files which you reference.

Hi mamue

Creating a DLL is one solution, and that certainly works very well.

If you don't want to do that, you can put your class in a .dot file, load
the .dot as a an addin (ie a global template). You can call code in that
addin from your templates. In the template, in the VB IDE, use Tools >
References to create a reference to the addin. Then, you can create an
instance of the class from the template in the same way as described at the
bottom of this page: http://www.cpearson.com/excel/ClassModules.htm. It's
written for Excel, but the principles are the same.

Hope this helps.

Shauna Kelly.  Microsoft MVP.
http://www.shaunakelly.com/word