Excel Keyboard Shortcuts when Recording Macros

[JCtheEUC]

When you record a macro in Excel and set it to a keyboard shortcut...Where/How does it save this? The VBA code shows it commented out. When you delete the code it removes the shortcut from memory. Any help would be appreciated.

Thanks!

 

[hkaplan2]

From an Internet search:

"It turns out that the shortcut key is stored in the Code Module, but it’s hidden from sight.

Export the Code Module (right-click the Module, click Export File) then open it in Notepad.

You will notice a line that looks like this:
Attribute Macro1.VB_ProcData.VB_Invoke_Func = “w\n14″"

 

[JCtheEUC]

Thanks hkaplan2!