Most macros I have created (and set up a button for on my toolbar) work just
fine. However, occasionally I create a macro that will only work by opening
the specific file I was working in when I created it. I cannot figure out
the distinction between the two scenarios, nor can I even find the macros
that are working fine without opening additional files.

I tried creating a macro in the default book.xlt template (which, amazingly,
had no macros in it), but even then, Excel wants to open book.xlt everytime I
want to run the macro.

How can I create macros and be sure they will work in all workbooks without
opening additional workbooks?