How to set macro buttons in excel

1. This example takes a screenshot of excel2003. After opening excel, click "menu bar -- tools --> custom", as shown in the following figure.

2. A "custom dialog box" is displayed, as shown in the following figure.

3. In the custom tab, find the command tab and click "macro" in the category. Then, a small expression icon is displayed on the right, as shown in the following figure.

4. In the above figure, press and hold the smiling face and drag it to the EXCEL toolbar. As you can see, the smiling face button appears in the toolbar.

5. Now the button is just a button, and we need to specify it. Now, in "tool-custom",

6. Then we also find the macro under the "command" in the custom. This is the right-click macro button, -- "" and then select the macro name in the pop-up window.

 

Now our settings are complete. This tutorial can be used in all versions of excel.