Is your code busy running and doing something while you are idle for a long
time? Usually, I put only UDFs (user-defined functions) and event handlers
in the template that are required to calculate any cell values. All other
command macro type of code (to load data into the template, select groups of
sheets to print, etc.) is put in a separate workbook and made into an add-in
so it is not copied with each data workbook saved from the template.
--
Regards,
Bill