Running cade on new file from template
 

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

Running cade on new file from template
 

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.

--

HTH

RP

"FTL" wrote in message
...
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