Excel template-run code on open
 

I have an Excel template where I'm trying to run code when
the template is called via File-New-Select template. I
thought I could put code in the workbook "on open" but it
only runs when you actually open the template, rather than
basing a new file on it. Any ideas how I can do this -
run code when the template is used to create a new doc?

Thanks

Cindy