I have a spreadsheet template MyTemplate.xlt. It has a couple of custom
buttons in it that are tied to macros. I have the macros assigned to the
buttons as MyTemplate.xlt!MyMacro looking only at macros in MyTemplate.xlt.

When I open a spreadsheet using the template (File| New...) the spreadsheet
opens and sometimes the buttons work correctly. If I close Excel (2003) and
reopen the buttons generate an error message that the macro
....MyTemplate1.xlt!MyMacro cannot be found. When I go back to the template,
the macro assignment has been changed and matches what the message indicated.

I've tried this on a couple of computers and gotten the same result. How
does the macro assignment get changed in the template to match a spreadsheet
copy generated from it? I'd appreciate any suggestions.

TIA,

John