Hi all.
I work with two workbooks open together.
I have a quite similar macro in both of them (but each one does the work in its own workbook). That's why they have the same shortcut key.
I've read that if there are multiple macros with the same shortcut key assigned, Excel will run only the macro that appears first alphabetically.
[http://www.bettersolutions.com/excel/ECC653/LC216621011.htm , step 3]
What is the best to bypass it, so the active workbook's macro will be always the one to run?
I work with two workbooks open together.
I have a quite similar macro in both of them (but each one does the work in its own workbook). That's why they have the same shortcut key.
I've read that if there are multiple macros with the same shortcut key assigned, Excel will run only the macro that appears first alphabetically.
[http://www.bettersolutions.com/excel/ECC653/LC216621011.htm , step 3]
It is possible to assign the same shortcut key to more than one macro in the same workbook using the (Tools > Macro > Macros) dialog box.
You cannot assign the same shortcut key though from the Record Macro dialog box.
If there are any macros that have the same shortcut key assigned, the macro that appears first alphabetically will be run.
What is the best to bypass it, so the active workbook's macro will be always the one to run?