If you have 2 Excel files open which both have macro's named the same and
assigned to the same shortcut key...it does not execute the current sheet's
macro. It runs the other sheets macro because it is listed first in the
global macro listing.
Is there a way to make it run the macro from the workbook that you are in?

ex.
I have 2 files...one called Test1.xls and the other Test2.xls....both having
Macro's assigned to ctrl+shift+Z. If I'm in Test2.xls....it will run the
Test1.xls macro.

Macro List
---------------------------
Test1.xls!Macro1
Macro1