...
Go to the Developer Tab.
In the Code section, click Record Macro.
In the Record Macro box, create a name for your macro that is meaningful to what your macro does. In the Shortcut Key, type in the key you want to activate the macro. In Store Macro in: Choose this workbook or your designated workbook“This Workbook” or the workbook you want the macro stored in. In description, explain what your macro does.
Click OK.
Rule 4: The keyboard shortcut shortcuts or “hot keys” assigned to a macro must not be the same as match an existing short cut.
...
| Warning |
|---|
CTRL C is already used in Excel as a hot key for copying. This cannot be used for another function. |
...