Shortcut key runs wrong code

[ackey]

Morning Experts

The VBA code to run all our company reports are run uses the same shortcut key (Ctrl r). This runs a Master routine which in turn runs a number of subroutines. This is fine when only one report is open at a time, however when the user has 2 or more such reports open, even though the only one may be the active workbook, sometimes it will run the code in one of the other workbooks. This is the case even if the settings are 'Macros in: This workbook'

Can anyone advise

Thanks in advance

Simon

 

[GlennUK]

I thought that shortcut keys operated on the first matching module in memory regardless of which workbook is active. In other words, this is expected behaviour in Excel, as far as I know.

What are the consequences when a macro in another book runs?