Put the macro in the Workbook_Open event of the template.

--

Vasant


"Nigel Downing" wrote in message
...
How can I automatically run a VBA macro based on the name of the template
the workbook was made from?
ie my template name is "bracing.xlt"
and I want all documents based on this to auto run a macro on opening.
(The macro will be used to load certain toolbars which are relevant to
only
these workbooks.
I can run it manually but I want to automate it)

Thanks in advance