OnKey to replace command button

Hello KJC,

To assign a "hot key" to a macro, it must not be part of another objects code. To create the stand alone macro and assign a hot key, follow the instructions below.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

Assign a Shortcut Key to the Macro
1. Press the keys ALT+F8 to display the Macro Dialog.
2. Click on the macro's name in the list.
3. Click Options... or press the keys ALT+O
4. Another dialog will appear. You can use combinations of CTRL, ALT, and Shift with a letter to create a shortcut key to run your macro.