|
How to make a list of all shortcut keys
I have tried to use VBA to make a list of all user-defined shortcut keys in
Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) |
How to make a list of all shortcut keys
Hi Helge,
Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user-defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) |
How to make a list of all shortcut keys
No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that
only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user-defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) |
How to make a list of all shortcut keys
Hi Helge,
My apologies, I missed the vital *user-defined* qualification. It may be possible but I am not aware of any way of returning macro shortcut assignments. --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user-defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) |
How to make a list of all shortcut keys
Norman & Helge,
I've just had a quick look at this, looks pretty good: http://www.xcelfiles.com/GetShortCutKeys.html Regards, Peter -----Original Message----- Hi Helge, My apologies, I missed the vital *user-defined* qualification. It may be possible but I am not aware of any way of returning macro shortcut assignments. --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user- defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) . |
How to make a list of all shortcut keys
Hi Peter,
Thank you for that. It looks Xcellent! I had in fact seen this on Ivan's site before but contrived to forgrt that I knew of its existence. --- Regards, Norman "Peter T" wrote in message ... Norman & Helge, I've just had a quick look at this, looks pretty good: http://www.xcelfiles.com/GetShortCutKeys.html Regards, Peter -----Original Message----- Hi Helge, My apologies, I missed the vital *user-defined* qualification. It may be possible but I am not aware of any way of returning macro shortcut assignments. --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user- defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) . |
How to make a list of all shortcut keys
If you run it, would you report back how long it took you,
the speed of your machine, and how many shortcuts it found, I figured it would take several hours with what I was supplied once before -- don't know if this is the same or not. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Peter T" wrote in message ... Norman & Helge, I've just had a quick look at this, looks pretty good: http://www.xcelfiles.com/GetShortCutKeys.html Regards, Peter -----Original Message----- Hi Helge, My apologies, I missed the vital *user-defined* qualification. It may be possible but I am not aware of any way of returning macro shortcut assignments. --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... I have tried to use VBA to make a list of all user- defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) . |
How to make a list of all shortcut keys
Hi David
ListMacro_ShortCutKeys.xla File size 83,968, dd 2004/07/04 I doubt I have anything like as many projects to run through as you, but for my purposes it's more than adequately fast. Takes a second or two to "warm up" then a few seconds for 20-30 projects (PII/350 - I like antiques!). Most contain no shortcuts, but all the details in those which do are correctly returned. You can select one / some / all workbooks and/or addins so no need to worry about it hogging your machine until you're confident about it. I did have a problem - code fails on some, but not all locked projects prompting the "End" dialog. Before this a new WB is added with a single sheet to list the shortcuts. I guess "SheetsInNewWorkbook" is changed to 1 and not reset because of "End". Thereafter each new WB opens with one sheet (easily reset manually in Tools Options General). I suspect this is easily fixed and I'll mail Ivan Moalla. That aside, I agree with Norman it is Xcellent and recommend to anyone in need of such a utility. Regards, Peter -----Original Message----- If you run it, would you report back how long it took you, the speed of your machine, and how many shortcuts it found, I figured it would take several hours with what I was supplied once before -- don't know if this is the same or not. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Peter T" wrote in message ... Norman & Helge, I've just had a quick look at this, looks pretty good: http://www.xcelfiles.com/GetShortCutKeys.html Regards, Peter -----Original Message----- Hi Helge, My apologies, I missed the vital *user-defined* qualification. It may be possible but I am not aware of any way of returning macro shortcut assignments. --- Regards, Norman "Helge V. Larsen" (AndThis) wrote in message ... No, I'm sorry. Chip Pearson provides a "master list" of short-cut keys that only includes the pre-defined short-cuts. But I am interested in a list that (also) includes my personal short-cuts. __________________________________________________ _______ "Norman Jones" wrote in message ... Hi Helge, Chip Pearson has already done the work for you! http://www.cpearson.com/excel/ShortCuts.htm --- Regards, Norman "Helge V. Larsen" <Helge.V.Larsen(RemoveThis) @Risoe.DK (AndThis) wrote in message ... I have tried to use VBA to make a list of all user- defined shortcut keys in Excel - but have found no object or collection that holds the definitions. Is it at all possible ? - and if it is, then HOW ? (System-defined shortcuts can be found by letting the Answer Wizard chew on "Print a list of shortcut keys".) . . |
How to make a list of all shortcut keys
Hi Peter...... Thanks for that. I have amended it. Appreciate your feedback. : -- Ivan F Moal ----------------------------------------------------------------------- Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195 View this thread: http://www.excelforum.com/showthread.php?threadid=26634 |
| All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com