Once your macro has been created, if won’t do you any good unless you can use it from time to time by running it. Now, you can certainly use the shortcut key you may have assigned when you created the macro, or you can follow the steps below.
Running A Macro Using the Ribbon
Open the workbook that contains the macro you want to run
Click the Macros command in the Code group on the Developer tab
Select the Macro you want to run
Running a Macro from the Quick Access Toolbar
First, you need to add the Macro to the Quick Access Toolbar, then you can use it.
Open the Office Menu
Choose Excel Options
Click the Customize tab
From the commands list, choose Macros
Figure 44. Excel Options Dialog Box - Customize Tab
5. Select your custom macro
6. Click Add
7. Click OK
8. Now, just click your new macro button on your Quick Access Toolbar