Where is the macro in Excel
There are several ways to run a macro in Microsoft Excel. A macro is an action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language. You can always run a macro by clicking the Macros command on the Developer tab on the ribbon. Depending on how a macro is assigned to run, you might also be able to run it by pressing a combination shortcut key, by clicking a button on the Quick Access Toolbar or in a custom group on the ribbon, or by clicking on an object, graphic, or control. In addition, you can run a macro automatically whenever you open a workbook. Before you run macrosBefore you start working on macros you should enable the Developer tab.
You can add a combination shortcut key to a macro when you record it, and you can also add one to an existing macro:
To run a macro from a button on the Quick Access toolbar, you first have to add the button to the toolbar. To do that, see Assign a macro to a button. You can create a custom group that appears on a tab in the ribbon, and then assign a macro to a button in that group. For example, you can add a custom group named "My Macros" to the Developer tab, and then add a macro (that appears as a button) to the new group. To do that, see Assign a macro to a button. Run a macro by clicking an area on a graphic object You can create a hotspot on a graphic that users can click to run a macro.
On the Developer tab, click Visual Basic to launch the Visual Basic Editor (VBE). Browse the Project Explorer to the module that contains the macro you want to run, and open it. All of the macros in that module will be listed in the pane on the right. Select the macro you want to run, by placing your cursor anywhere within the macro, and press F5, or on the menu, go to Run > Run Macro. Create a Workbook_Open event. The following example uses the Open event to run a macro when you open the workbook.
Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. Top of Page See AlsoAutomatically run a macro when opening a workbook Automate tasks with the Macro Recorder Record a macro to open specific workbooks when Excel starts Create and save all your macros in a single workbook Save a macro |