How about doing all the calculations and moving the
worksheet to another workbook. This way you can
eliminate the macros  in the destination workbook. I
have a similar appliction that generated 15 sheets of
report. I generate  this using Access and Excel and
involves 3 - 5 formatting for each sheet. I have
written the code in Access and formatting in Excel.
Finally once the Job is done i create another workbook
and transfer the sheets to another workbook. By this
way the Template file remains unaffected.