Hi
First of all this should be posted in the Office section not the Excel section.
Are you saving the template as a macro enabled template?
Also are you saving the macro in the template rather than the normal template when you create it.
Hope this helps.
Tony (OTPM)