One of the fastest ways to run a macro is to create a shortcut key for it.

You don't need to put a button on your toolbar or even click anywhere. As a matter of fact, your hands don't even have to leave your keyboard!

You can create a shortcut key to run a macro before you even record it. Follow the steps below to learn how.

1. Choose Tools | Macro | Record New Macro or double-click REC on the Status bar.
    
2. Enter the name for the macro.
    
3. Click Keyboard to see the Customize Keyboard dialog box.
    
4. Choose the macro name.
    
5. Click the Press New Shortcut Key box.
    
6. Press the key combination you want to use. If the shortcut key is already in use, the current assignment will appear in the dialog box.
    
7. Click Assign after you have chosen the shortcut key.
    
8. Close the dialog box.

Now, when you press the shortcut keys you assigned, your macro runs!

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!