You can assign a assign macro to a button to a custom tab on the Ribbon or a custom button on the Quick Access toolbar in Excel 2013 and then run it by clicking that custom button. Excel displays the Customize Ribbon pane in the Excel Options dialog box.
In the Choose Commands From list box on the left, quickly remove all macros from active workbook or from all workbooks in many folders Kutools for Excel provides two workarounds for Excel users to easily remove all macros in workbook. Click Macros in the Choose Commands From drop, click the name of the macro you want to add to the custom group now selected in the Main Tabs list box on the right. Just like Chrome, excel displays the Customize Ribbon pane in the Excel Options dialog box. Click the Rename button at the bottom of the Main Tabs list box and then type a display name for the new custom tab before you click OK. Don’t need any special skills, click OK to close the Excel Options dialog box. To run the macro, click the New Tab button at the bottom of the Main Tabs list.