Hardware Reference
In-Depth Information
Make VBA Macros Easier to Find
Going through Tools > Macro > Macros and a separate window whenever you want to run a
macro is a drag. Fortunately, you don't have to. You can assign a keyboard shortcut to your
macro, put it on a menu, or both.
Assign a Keyboard Shortcut to a VBA Macro
In Word or Excel (but not PowerPoint), you can assign a keyboard shortcut to your macro:
1. Choose Tools > Customize Keyboard.
2. In the Categories list on the left, select Macros.
3. In the Commands list on the right, select the macro you want to assign a
keystroke to.
4. Click in the Press New Keyboard Shortcut field.
5. Press the key combination you want to use. (See the sidebar Use Multi-Key
Shortcuts in Microsoft Word , below, for a special tip.)
6. Click Assign.
7. Click OK to dismiss the window.
From now on, you can activate your macro with that keyboard shortcut.
Search WWH ::




Custom Search