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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)