Sunday, July 31, 2005

Short Cut keys for Macros


You can create your own short cut keys for Excel VBA Macros you write.
To do this go to Tools | Macro |Macros (ALT+F8) and then select the macro you want to create the shortcut for.
Click Options and then create the keystroke combination you want. I usually hold down the SHIFT key and a letter, eg SHIFT+H. This creates a keystroke combination of CTRL+SHIFT+H and when that is pressed this macro will execute.

The reason to use SHIFT as well as CTRL (which is automatic) is to avoid regular Excel shortcut key combinations.
Check my page of Excel shortcuts for a huge list of shortcuts.


Posted by: Jethro | 5:17 PM |