Hello,
My work team uses a variety of Excel macros that have been created and shared by hundreds of people in our offices. Sometimes, we might receive a shared file and in that shared file will be hotkey shortcuts that override previous hotkey shortcuts. For example, my "Control-Shift-T" macro might copy-paste-special all values in a sheet, but in the new Excel file I received, "Control-Shift-T" might change column A from no fill to yellow fill.
Is there a bit of code I can run that will return locations of all defined (whether they be Excel or custom-made) hotkey shortcuts? I'm envisioning something that of a print-out that lists:
"Control-Shift-T" = module 7 in macro X
"Control-Shift-T" = module 3 in macro Y
"Control-P" = print
and so on and so on for all Excel and custom made hotkey macros.
Thanks!
