![]() Rather than creating a keyboard shortcut, you can add a macro button to the Quick Access Toolbar. Adding a Macro Button to the Quick Access Toolbar Note: The CTRL + SHIFT + single letter keyboard combination may work best for a macro shortcut due to the many Excel shortcuts which already use the CTRL + single letter combinations. In addition, use a single letter with the CTRL or Shift keys. Just make sure that you do not use an existing Excel keyboard shortcut (such as CTRL B, which bolds a cell). When revising shortcuts, it doesn’t matter whether you saved the macro in this workbook or in the Personal Macro workbook. Here you can view the macro shortcut and description, assign a shortcut, or modify the existing shortcut keys. ![]() You will see the Macro Options dialog box: This dialog box shows the shortcut key. To view your macro shortcut keys, on the View tab of the Ribbon, click the Macros button, select your macro, and choose Options…. However, you may eventually forget the shortcut, or if you didn’t assign a shortcut key when you first recorded the macro, you may now like to assign one – or perhaps you have even decided to change the shortcut key to something different. Do you find yourself forgetting keyboard shortcuts for your Excel macros? When first recording a macro, you will have an opportunity in the Record Macro dialog box to specify a shortcut key for the macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |