Shortcut key executes macro in another workbook

[lamotu]

Have assigned shortcut key CTRL+L to macro ControlL in workbook. Upon execution macro references a specific configuration worksheet within the workbook. This works fine. However, I have similar module and and macro in another workbook. If both workbooks are open the wrong instance of ControlL is sometimes executed. How can I ensure macro ControlL in active workbook is always invoked?

[foxguy]

Here's how I would do it:

Put 1 macro ControlL in Personal.xls, and a sub "FileControlL" in each workbook. Have Ctrl+L execute Personal.xls!ControlL() and that macro selects the active workbook to run the individual FileControlL().

Please Login or Register  to view this content.