Enumerating Assigned ShortCuts in Excel

Question

I frequently create new macros in Excel. When assigning the macro to a shortcut key combo it is necessary to try many times before getting one that is not already in use. I want to determine all of the "used" shortcuts either from VBA or any other method available.

Answer 1

Here's one way (not super convenient but it works)

1. Export your code module as a .BAS file using File > Export
2. Open the .BAS file with a text editor
3. You'll see lines like this:

Attribute f.VB_ProcData.VB_Invoke_Func = "q\n14"

That means that this function is assigned to Ctrl+q.