Bob,

When you say "one of my macros" I am assuming that you wrote it. If so, you
could:

a) Attach the template instead of adding it
b) Open any one macro using the VBEditor
c) Click on Debug and Compile Project. You should be able to see where the
error lies. You should post the code here if you can't fix it. Also, click
on Tools - References and ensure you see nothing  'missing'. If something's
missing, you should install it (like a OCX or so forth)

This should get you started.

Vince