a list of all macros and their key combinations?
This is my second try at getting an answer to a seemingly simple question:
How to list, using a VBA code or even a macro, all the custom key combinations and their corresponding macros which are active in the currently open spreadsheets? The list should take into account the selection made in the 'Macros in:' box, such as This workbook, All open workbooks or Personal.xls. I'd like to see which key combinations are still for the taking (instead of the trial-and-error method I use now or having to go through all the active macros one by one and checking under Options which key compination runs it, to see which Ctrl-Shift-letter combinations I can still use...) z.entropic |
a list of all macros and their key combinations?
see:
http://www.xcelfiles.com/GetShortCutKeys.html for a very valuable add-in -- Gary''s Student - gsnu200749 "z.entropic" wrote: This is my second try at getting an answer to a seemingly simple question: How to list, using a VBA code or even a macro, all the custom key combinations and their corresponding macros which are active in the currently open spreadsheets? The list should take into account the selection made in the 'Macros in:' box, such as This workbook, All open workbooks or Personal.xls. I'd like to see which key combinations are still for the taking (instead of the trial-and-error method I use now or having to go through all the active macros one by one and checking under Options which key compination runs it, to see which Ctrl-Shift-letter combinations I can still use...) z.entropic |
a list of all macros and their key combinations?
See if this gets you started.
http://www.xcelfiles.com/GetShortCutKeys.html z. entropic wrote: This is my second try at getting an answer to a seemingly simple question: How to list, using a VBA code or even a macro, all the custom key combinations and their corresponding macros which are active in the currently open spreadsheets? The list should take into account the selection made in the 'Macros in:' box, such as This workbook, All open workbooks or Personal.xls. I'd like to see which key combinations are still for the taking (instead of the trial-and-error method I use now or having to go through all the active macros one by one and checking under Options which key compination runs it, to see which Ctrl-Shift-letter combinations I can still use...) z.entropic |
a list of all macros and their key combinations?
Great thanks both to Gary"s (or should it be Gary's?) student and JW (who
suggested the same perfect solution within 3 minutes of each other...) :-) z.entropic "Gary''s Student" wrote: see: http://www.xcelfiles.com/GetShortCutKeys.html for a very valuable add-in -- Gary''s Student - gsnu200749 "z.entropic" wrote: This is my second try at getting an answer to a seemingly simple question: How to list, using a VBA code or even a macro, all the custom key combinations and their corresponding macros which are active in the currently open spreadsheets? The list should take into account the selection made in the 'Macros in:' box, such as This workbook, All open workbooks or Personal.xls. I'd like to see which key combinations are still for the taking (instead of the trial-and-error method I use now or having to go through all the active macros one by one and checking under Options which key compination runs it, to see which Ctrl-Shift-letter combinations I can still use...) z.entropic |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com