I have 2 Workbooks. They contain different data and sheets, but have some same macro names, which are being ran by the same keybord shortcuts.
For example: both have Sub ArrangeTitles() macro which is being called by Ctrl+Shift+R. The vba codes inside these Subs are different.
The problems start when both Workbooks are open and the user presses
Ctrl+Shift+R, which sometimes runs the wrong Sub (the "other Workbook's Sub"), and this is according to the order of opening the Workbooks.
My goal is to be able to activate the right macro which belongs to the right Workbook, without changing any names or shortcuts.
I have looked for a solution for this all around the web with no success. So I figured out some-kind of bypass solution which works well. I will soon add the answer here.