Can I get a list of the defined keyboard shortcuts for a sheet?

[JenniferMurphy]

I want to assign a macro (Sub) to a keyboard shortcut. When I do this in Word, it tells me if the shortcut is already defined so I don't screw anything up. Excel does not appear to do this.

Is there a way for me to find out what all of the extant shortcuts are in any sheet?

 

[NAP2012]

https://support.office.com/en-ie/ar...-windows-1798d9d5-842a-42b8-9c99-9b7213f0040f

This provides all the shortkeys in excel by version.

 

[JenniferMurphy]

https://support.office.com/en-ie/ar...-windows-1798d9d5-842a-42b8-9c99-9b7213f0040f

This provides all the shortkeys in excel by version.

Thanks, that's helpful. But it only tells me what the default assignments are. I was hoping to get a list of the current assignments, whi9ch would include any that I may have changed in this sheet.

 

[Tetra201]

Maybe this (untested).

 

[JenniferMurphy]

Maybe this (untested).

The latest post in that thread says it no longer works (as of Excel 1026).