I have a project that requires two open linked workbooks. One workbook has a number of macros assigned to CTRL- shortcuts.

How can I make each macro only work on one workbook? If I have the second workbook selected and implement a macro shortcut that is intended for the first workbook, Excel tries to apply the macro to the second workbook.

Is there a way to insure that a macro only works on the intended workbook?