Assuming the macro is actually in the template itself then are you sure that it isn't being blocked by users' macro security?