MS Excel Chapter 9: Macros

Instructions

Section 9.1: Rules for Creating Accessible Macros

  1. Each macro must have a meaningful name that matches its function.

  2. Each macro must have a clear and complete description of what it does.

  3. A keyboard shortcut must be assigned to each macro.

  4. The keyboard shortcuts or “hot keys” assigned to a macro must not match an existing short cut.

  5. Users must be alerted that macros are being used in a document. They should know how many of them there are, the name, description, and hotkey of each macro.

Hot Keys Example

Instructions to adding a keyboard shortcut.

  1. Go to the Developer Tab.

    Developer Tab in Microsoft Excel.
  2. In the Code section, click Record Macro.

    Record Macro button in Microsoft Excel.
  3. 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 the workbook you want the macro stored in. In description, explain what your macro does.

  4. Click OK.

CTRL C is already used in Excel as a hot key for copying. This cannot be used for another function.

CTRL R is not used for anything in Excel, so it is safe to use for a macro.

Hot Key Description Example

Related articles