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

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