It is possible to assign the same shortcut key to more than one macro in the same workbook using the (Tools > Macro > Macros) dialog box. To create a shortcut key that includes the Shift key just press the Shift key while you press the letter.Īny shortcut key that you assign to a macro will take precedence over the built-in shortcut keys, so be careful. You can either use just the Ctrl key or a combination of both the Ctrl key and the Shift key. Select the macro that you want to assign a shortcut key to and press the "Options" button. Select (Tools > Macro > Macros) to display the Macro dialog box. You could run your macro by using a shortcut key. The Descriptive box can be used to add a short description to your macros and is only visible in the (Tools > Macros > Macro) dialog box when the macro is selected. You don't have to set this before recording your macro. You can add or change a short-cut key at any time. If you enter "B" in uppercase you can execute the macro by pressing (Ctrl + Shift + "b"). You can execute the macro by pressing (Ctrl + "b"). Avoid overwriting common shortcut keys such as (Ctrl + "C" or Ctrl + "V"). It is important to realise there is a good chance you will be overwriting an existing shortcut key so test first to make sure you will not miss it. This will invoke the shortcut Ctrl + Shift key. Shortcut keys are case sensitive and you can use just the Ctrl key or a combination of both the Ctrl key and Shift key. Remember that any key combinations you assign to macros will take precedence over any built-in shortcut keys. If you add a description before recording a macro then this description will appear as a comment on the first few lines of the recorded VBA code. You can add either a Shortcut Key or a Description to your macro by selecting (Tools > Macro > Macros) and selecting the "Options" button at the bottom.
This does not have to be done when you record the macro and can easily be done afterwards. You can hold down the Shift key when selecting your key. When assigning a shortcut key remember the letter you press is case sensitive.
0 kommentar(er)
