Autorun macro on starting a template
 

Hi, using help from this forum, I've placed a macro in my workbook that runs
correctly when the workbook is opened. However, when I change the workbook
into a template (.xls to .xlt), the macro does not run. I think this must be
something very obvious!

Thanks,
Geoff.

Autorun macro on starting a template
 

A workbook_open event should fire if you do File=New and select you
template as the basis of the workbook.

If you are creating a new workbook or opening your template by running a
macro started with a key combination that includes the shift key, change the
combination so as not to include the shift key.
--
Regards,
Tom Ogilvy

"Geoff C" wrote in message
...
Hi, using help from this forum, I've placed a macro in my workbook that
runs
correctly when the workbook is opened. However, when I change the workbook
into a template (.xls to .xlt), the macro does not run. I think this must
be
something very obvious!

Thanks,
Geoff.