4 Ways To Create A Custom Macro Button In Excel

Click File → Options → Customize Ribbons Find the Developer check box in the Main Tabs section and click it. Press “OK” when you are done.

Go to Excel → Preferences → Ribbon (Under Sharing and Privacy) Under Customize, check the box next to the Developer tab, and press “OK”

If you are unfamiliar with what macros are or how to record them, read more. You should have a macro already built before you create the button.