I am using Excel 97.

I have written some temples in Excel which utilise some
code in VBA to complete some of the fields, these all work
fine.

I also have a custom toolbar with buttons which call
macros in the same template.

For some reason the code behind the buttons don't stay
with the template. When I create a spreadsheet from one
of these templates, the path of the code changes and the
code can't be found. Any solutions would be appreciated.


Mark