Running cade on new file from template

[FTL]

Hi
Anyone who can tell me how to run some code when I make a new workbook from
a template?
I want it to run only when I create a new document, not when opening it
later.

FTL

 

[Bob Phillips]

Have the code as workbook open code, and then at the end delete it.

See http://www.cpearson.com/excel/vbe.htm to update code on the fly.

Might be a good idea to use OnTime to trigger a delete macro at the end of
the workbook open routine. Again, see
http://www.cpearson.com/excel/ontime.htm for details.