To resize the button, drag the sizing handles.
In the Assign Macro dialog box, click the name of the macro that you want to assign to the button, and then click OK. In the Customize the Ribbon section, under Main Tabs, check the Developer check box, and press OK.Ĭlick the worksheet location where you want the upper-left corner of the button to appear. On the Developer tab, in the Controls group, click Button. Your new group appears on the tab you picked, where you can click the button to run the macro. Under Symbol, select a button icon for your macro. To use a friendlier name, click Rename, and then type the name you want in the Display name box. The macro is added to the My Macros group. Select the macro you want to add to your new group, and then click Add. To add a macro to the group, in the Choose commands from list, click Macros. To use a better name for your new group, click Rename, type the name you want in the Display name box, and then click OK. That adds New Group (Custom) to the tab you picked. Pick the tab where you want to add your own group.įor example, pick Home, to add your group to the Home tab. Under Customize the Ribbon, in the Main Tabs list, check the Developer box if it is not already checked. Add a macro button to your own group on the ribbon Tip: When you save the workbook, buttons you assign to macros in the personal workbook will be available in every workbook you open.
