Assign keyboard shortcut to run procedure

by

According to Microsoft’s documentation

  1. On the Tools menu, point to Macro, and then click Macros.

  2. In the Macro name box, enter the name of the macro you want to assign to a keyboard shortcut key.

  3. Click Options.

  4. If you want to run the macro by pressing a keyboard shortcut key, enter a letter in the Shortcut key box. You can use CTRL+ letter (for lowercase letters) or CTRL+SHIFT+ letter (for uppercase letters), where letter is any letter key on the keyboard. The shortcut key cannot use a number or special character, such as @ or #.

    Note: The shortcut key will override any equivalent default Microsoft Excel shortcut keys while the workbook that contains the macro is open.

  5. If you want to include a description of the macro, type it in the Description box.

  6. Click OK.

  7. Click Cancel.

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. How to avoid using Select in Excel VBA
  3. How do I use FileSystemObject in VBA?
  4. Is the . in .Range necessary when defined by .Cells?
  5. Run Excel Macro from Outside Excel Using VBScript From Command Line
  6. Importing text file into excel sheet
  7. Checking for #N/A in Excel cell from VBA code
  8. Non-web SQL Injection
  9. Error: “Could Not Find Installable ISAM”
  10. Filling any empty cells with the value above
  11. Password hash function for Excel VBA
  12. Aggregate, Collate and Transpose rows into columns
  13. One-dimensional array from Excel Range
  14. VBA Excel sort range by specific column
  15. How to delete multiple rows without a loop in Excel VBA
  16. VBA Many buttons point to the same _Click sub
  17. Excel VBA Filter Change event handler
  18. How to suppress Update Links warning?
  19. How do we use restful APIs from Excel macros (vba)?
  20. Cannot VBA write data to cells in Excel 2007/2010 within a function
  21. VBA paste as values – how to
  22. How to send email to multiple recipients with addresses stored in Excel?
  23. What are the benefits of using Classes in VBA? [closed]
  24. Writing a VLOOKUP function in vba
  25. Handle cancellation of InputBox to select range
  26. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  27. VBA: How to combine two ranges on different sheets into one, to loop through
  28. Access files with long paths (over 260)
  29. Concatenate multiple ranges using vba
  30. How to highlight selected text within excel

Leave a Comment