View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Downing Nigel Downing is offline
external usenet poster
 
Posts: 3
Default Macro Runs if Template name is .....

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