If I create a new XL workbook based on a template then the new workbook
contains all the macros that are in the template.

However:
If one of these macros creates a new workbook based on the same template
(i.e. using Workbooks.Add Template:=TemplateLocation) then the resulting
workbook does not contain the template macros.

If I haven't explained this properly then please shout and I'll post more
info.
Any help would be much appreciated.

Thanks

Philip