How to create Macro Buttons?

How to add a button and assign a macro to it in a worksheet, to run a macro that performs an action when a user clicks it?

1 Answer(s)


To create Macro buttons, follow the given steps.

1) Click the Insert button under Developer tab, and select the first option under the Form Controls

2) Draw a button in working area.

3) Then the 'Assign Macro' dialog box pops up, select the macro you want to assign to this built button, and click OK.