![]() To me all above answers are unsatisfactory because they limit what combinations I can use as custom shortcuts or what actions I can target, or they require way too much work for something that should be simple. With VBA you can actually create longer combos like Ctrl-Shft-N (one of my favorites). You only have the choice of Ctrl and one key, I believe. With #3 it's still the same as it was in earlier versions, just go into the Macro dialog and change the shortcut in Options. still exist behind the scenes in Excel 20 and can be accessed via code). The only way I know to do this now would be to change the toolbar name in VBA (the old toolbars, File, Edit, etc. For example you could change the name of the Edit menu from &Edit to &Zdit and the shortcut sequence in #2 above would be changed to Alt-Z-S-V. You use to be able to do #2 in Excel by going into Tools > Customize and then changing the location of the ampersand. ![]() ![]() Of course you can write a macro in Excel that changes the Bold property and then assign a keyboard shortcut to it, but that really falls under #3 above. I don't think Excel has ever allowed you to do this. With # 1 I think only Word allows you to change these, e.g., you can change the shortcut for Bold from Ctrl-B to something else. There are 3 different kinds of keyboard shortcuts I know of:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |