Forum Discussion

Kegan Reiswig's avatar
Kegan Reiswig
Copper Contributor
Jun 15, 2018

Need to return all custom hotkey macros

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!

No RepliesBe the first to reply

Resources