| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
\uD83D\uDCD8 Instructions
Section 9.1: Rules for Creating Accessible Macros
Rule 1: Each macro must have a meaningful name that matches its function.
Rule 2: Each macro must have a clear and complete description of what it does.
Rule 3: A keyboard shortcut must be assigned to each macro.
Instructions to adding a keyboard shortcut.
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. In description, explain what your macro does.
Click OK.
Rule 4: The keyboard shortcut or “hot keys” assigned to a macro must not be the same as 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. |
| Tip |
|---|
CTRL R is not used for anything in Excel, so it is safe to use for a macro. |
Rule 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.
\uD83D\uDCCB Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|