Record Macro Button. Click the developer tab. Below we will create the button on a worksheet and assign a macro to it.
Then click the macros drop down button in the macros button group. Shapes give us the most styling formatting options and we can make them look like buttons you click every day on modern web pages. Meanwhile excel will remain in a recording state until you click stop recording in the code section of the developer tab.
Then click the drop down part of the macros button in the macros button group.
Using shapes to create macro buttons. After we set click ok to add the button to the quick access toolbar. In the code group click on the macro button. Then select the record macro command to open the record macro dialog box.