I'm one shortcut-key-using-maniac (Elftree user, naturally) and seek advice from others with a similar affliction. It regards keeping track of many shortcut keys, and not walking on preassigned ones. For this question, I am thinking in terms of Excel macros, but wouldn't mind related info on M.S. Office products. (Moreover, does Access even have a way to assign shortcut keys to macros? Queries or reports?! Oooh, tell me if so)
Regarding keeping track, can I list out what is assigned? Right now I go alt-F8 and arrow down, watching the descriptions. However this presumes that I began each desctiption with something like "kbd:Ctrl-H" or such (yeah, right, I always remember to do that - NOT). Is there another way to list what I've got?
Regarding walking on (conflicting w/) preassigned keys, note how Word does it ... as soon as you click Keyboard (when you begin to record one) and hit the shortcut keystroke, it shows exactly what is currently assigned (yet listing out my assigned keys later seems to be something they blew). You power gurus - what is an efficient tactic for assigning uniquely, and not inadvertently stabbing myself? (E.g.: I assign Ctrl-B to my atomic annihilation macro, forgetting at the time that it's the built-in Bold shortcut; then I go to "embolden" a word later, and set off the bomb.)
TIA
Regarding keeping track, can I list out what is assigned? Right now I go alt-F8 and arrow down, watching the descriptions. However this presumes that I began each desctiption with something like "kbd:Ctrl-H" or such (yeah, right, I always remember to do that - NOT). Is there another way to list what I've got?
Regarding walking on (conflicting w/) preassigned keys, note how Word does it ... as soon as you click Keyboard (when you begin to record one) and hit the shortcut keystroke, it shows exactly what is currently assigned (yet listing out my assigned keys later seems to be something they blew). You power gurus - what is an efficient tactic for assigning uniquely, and not inadvertently stabbing myself? (E.g.: I assign Ctrl-B to my atomic annihilation macro, forgetting at the time that it's the built-in Bold shortcut; then I go to "embolden" a word later, and set off the bomb.)
TIA
