How to Assign a VBA Macro to a Button in Excel
How to Assign a VBA Macro to a Button in Excel
To assign a VBA macro to a button in Excel, enable the Developer tab via File - Options - Customize Ribbon. In the Developer tab, click Insert and select Button (Form Control), then draw the button on your worksheet. Write your macro in the VBA editor, then right-click the button, select Assign Macro, choose your macro, and click OK. Clicking the button will now run your macro.
Drop a comment if you are interested in "Add Custom Borders" macro featured in this video to get the code.