To run a macro click on Tools/Macros/Macro (2003) or View/Macros/View Macros (2007/2010). A dialog box will appear, listing the macros available to be run. You can filter the list of macros displayed by making a selection in the "Macros in" field. The names of macros in open workbooks other than the active workbook are preceded by the name of the containing workbook plus an exclamation point. Once you have selected the macro, click on "Run."
Remember that when you run a macro, it runs on the active worksheet (no matter where the macro is stored), unless specified otherwise by the appropriate macro commands. For the purposes of this tutorial we will assume that the macros will run on the active worksheet.
To repeat an important point made earlier, with certain actions that involve entering settings on a dialog box, such as page setup, when you record a macro all the settings on the dialog box are recorded, not just the one(s) you change. This needs to be kept in mind when recording and running macros. This subject is covered in detail later in this tutorial.
endless loop into the macro, you can stop the macro by pressing the Escape key. A VBA message box will open; select "End" to terminate the macro.