I have a workbook in which I have some macros. I use this workbook quite a bit as a starter workbook and would like to add it to my templates.

I have a toolbar in which I have buttons to run the macros. I have attached the toolbar to the workbook and the macros are in a standard module in this workbook.

My problem is that if I save the workbook as a template, when I use the template to create a new workbook, the toolbar buttons are now referring to the macros in the template, rather than the macros in the newly created worksheet.

Example:
If my workbook is named "MyStandard.xls" and I save it as a template it is now named "MyStandard.XLT".

When I create a new workbook from the template it is named "MyStandard1xls"

However, the toolbar buttons refer to the macros in "MyStandard.XLT" rather than to "MyStandard1.xls"

~*~*~*~
Can I save the worksheet so that the macro buttons will refer to the macros in the newly created worksheet?