Run excel macro using an icon

Run excel macro is very easy. And there are actually many ways to run the macro. Given below are some methods which you could use to run the macro:

1. Go to menu, click on tools, --> macro --> macros. When the Macro dialog box appears, select the macro and click on the run button.

2. Use a form button and assign the macro to this button.

3. Use a short cut key (e.g. Press the CTRL key together with a character) to run excel macro. You can set up the short cut key when you start recording a macro. If you have created the macro, you can set the short cut key by going to menu, click on tools, --> macro --> macros. When the Macro dialog box appears, select the macro and click on the option button.

5. In the following section, we will show you how to assign the macro to an icon so that the macro can be run by clicking on the icon. We will use the macro which we have created in the tutorial “record a macro” for this tutorial. Click here if you need to find out how to create the macro.

   a. Click on the right mouse button.

   b. Select Customize.

   c. Go to the Command Tab, select the Category called Macros.

   d. Go to list on the right side of the dialog box called Commands. Select Custom Button / Icon.

   e. Drag it to the formatting toolbar.

   f. To modify the button image, click on the modify selection on the Customize Dialog Box, go to change button image. Select your preferred image.

   g. Go to modify selection again and select assign Macro.

   h. Select the Macro named “Custom_Num_Format” and click OK.

   i. Close the Customize Dialog Box.

6. Enter some numbers into the worksheet and test out your new macro.

7. Once you have done the above steps, you will be able to run excel macro using the icon.