How does XL "lose" a macro that's right there?
 

Working on a macro for a while. I have a tool on a toolbar assigned to that
macro. It worked just fine until this morning. When I click on the button,
I get an error, "The macro "Tribal TR Template V1.xls'!Create TR' cannot be
found". Yet the worksheet with that name and the macro with that name are
both there, right in front of me.

I've gone in and reassigned that button to that macro, which is there in
the list of macros, and I still get the same message. I created another
button on another toolbar and assigned it to this macro and still get the
same message!

Does anyone know what this could be?