Another user interface option at your disposal is to create custom shortcut keys. Excel lets you assign a Ctrl key (or Shift+Ctrl key) combination (shortcut) to a macro. When the user presses the key combination, the macro executes.
Be aware, however, of these two caveats: First, you must make it clear to the user which keys are active and what they do; second, you need to be careful not to assign a key combination that's already used for something else. A key combination that you assign to a macro takes precedence over the built-in shortcut keys. For example, Ctrl+S is a built-in Excel shortcut key used to save the current file. If you assign this key combination to a macro, you lose the capability to save the file with Ctrl+S. Remember that shortcut keys are case-sensitive, so you can use a combination such as Ctrl+Shift+S.
Was this article helpful?