How do I find out what macro a particular keyboard shortcut is assigned to?

I was editing a file and used CTRL+r to fill right. But instead, it grabbed a big chunk of my worksheet and deleted it, and may have done other things as well.

The file I was editing was not a macro-enabled file, and no other macro-enabled file was open, except PERSONAL.xlsb.

I suspect that one my macros in PERSONAL was assigned CTRL+r, probably accidentally as I would avoid reusing a predefined shortcut. But I have dozens of macros in there.

Is there any way to trace this, other than by individually examining each Sub to see which one is invoked? Worst-case scenario is that the shortcut refers to a Sub that is not currently open.

I found a link on one of Allen Wyatt's pages that refers to a tool someone wrote to generate a list of shortcuts to macros, but that link does not go where it says it goes.

Ivan's page disappeared ages ago sadly. I have a copy of his add-in though, which I hope he won't mind me linking here.

Thanks Rory. I installed it but couldn't figure out how to run it, and the code is password-protected. Meantime I wrote my own quick and dirty code to do this with some research, based on something Andy Pope posted on another forum about 10 years ago.

Here's where things get weird. I do not have any shortcuts defined for my of my own macros. Just to make sure the code was working I added one, and it was properly listed.

Either a built-in Excel shortcut has been corrupted (highly unlikely IMHO) or there is some other shortcut coming into play that I can't find, maybe at the Windows level.

See corrected code in post below

A little too quick and too dirty. Working on a bug fix to this code, stand by.

Hello 6StringJazzer,

Maybe this Link could be of some help.

Kind regards.

Originally Posted by 6StringJazzer

Thanks Rory. I installed it but couldn't figure out how to run it

It should add a button to the add-ins tab. If you don’t see that, you’ll need to unblock the .xla in Explorer first.