title: automatically run excel macro upon creation from template
body: <p>I want to create an excel template that will includes formulas for dating the columns. However, since those formulas will be based on <code>TODAY()</code>, I need to convert them to static strings (so the dates don't change everytime someone opens it). Is there a way to add a macro that will run automatically when someone creates a new spreadsheet based on the template? (Similarly to <code>Auto_Open()</code>, only on Create, rather than Open). If so, I could just create a macro that will <a href="http://office.microsoft.com/en-us/excel-help/replace-a-formula-with-its-result-HP010066258.aspx" rel="nofollow">replace the formulas with their results</a> upon document creation. Can this be done?</p>
  
  <p>[Note: I'm not married to this solution; it just seemed like the simplest way to protect my spreadsheet. If someone can suggest an alternative approach, I'd be obliged.]</p>