How to Create a Custom Macro Button in Excel

Step-by-Step Guide

1. 1

   Step 1: Make sure the Developer tab is displayed.

   The Developer tab is a tab in the Ribbon at the top of Excel.
   
   If it is not displayed, follow these directions in order to display it:
   Click File → Options → Customize Ribbons Find the Developer check box in the Main Tabs section and click it.
   
   Press "OK" when you are done. ,, Select Macro.
   
   Thereafter, all recorded macros will appear in the left box. ,, Right-click and select Rename. ,
2. 2

   Step 2: Add "New Group" under the Developer Tab to create a custom group for the command/button that will be created.

3. 3

   Step 3: Still in the Customize Ribbon

4. 4

   Step 4: click on the dropdown menu to choose command.

5. 5

   Step 5: Select the desired macro for button creation (make sure the newly added group is highlighted

6. 6

   Step 6: you will know if the macro was added when it appear in the right box under your new group).

7. 7

   Step 7: You may now customize your button.

8. 8

   Step 8: If everything is set

9. 9

   Step 9: Click "OK"

Detailed Guide

About the Author