If you have a workbook that uses some VBA code and you want an easy way for someone to run the code (i.e. without them having the Developer tab enabled) then a form control button is a good option. The good thing about form control buttons is they can be made very prominent and labelled accordingly like “Click Here To Run” so a user will know what to do.
Add your button to a sheet.
- Go to the Developer tab in the ribbon. If you don’t see this tab, read How To Enable The Developer Tab.
- Press the Insert button found in the Controls section.
- Select the Button Form Control from the menu.
- Right click and hold the mouse then drag and release to create your button.
- The Assign Macro window will pop up and you can select the VBA procedure you want to run from the button.
- Press the OK button.
To re-label the button to something more meaningful than button1, left click on the button and select Edit Text from the menu. You can also re-assign you button from this menu by selecting Assign Macro.