Forum Discussion
Macro execution
How do I attach a macro to a button so the user merely has to click the button to execute the macro?
Scott,
First, you have to enable the https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45, then go to:
Developer >> Controls >> Insert
From the Form Controls group, select Button (Form Control) which is located in the left-hand corner, and drop it to the worksheet!
After that, the Assign Macro dialog box will automatically appear so that you select any existing macro and assign it to the button!
If you miss this dialog box, you can right-click on the button, and select Assign Macro.