hi,

i've created several macros in ms excel. i have a template i use and then i
run the macros. the first time i run the macros they work fine but the next
time i try to run it again it is trying to access the macro from the first
document created using that template. In other words, if the template is
comparison.xlt and i open a workbook using this template it is labeled
comparison1.xls. After i run the macro and close this document w/o saving the
next time i run the macros it is looking for comparison1.xls otherwise it
wont work. Why is it doing this if i created the macros for all open
workbooks? can anyone help?

Thank you