1-866-245-5224 sales@keystonelearning.com

Excel 2003: Run a Macro

Excel 2003: Run a Macro

Once your macro has been created, it 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 these steps.

Running a Macro Using the Menu Bar

     
  1. Open the document that contains the macro you want to run
     
  2.  
  3. Choose Tools: Macro: Macros… from the Menu bar
     
  4.  
  5. Select the Macro you want to run
     
  6.  
  7. Click Run
     

Running a Macro from the Toolbar

First, you need to add the Macro to a toolbar, then you can use it.

     
  1. Choose Tools: Customize… from the Menu bar
     
  2.  
  3. Click the  Commands tab
     

Figure 24. Customize Dialog Box - Commands Tab

   3.      Under Categories, scroll down and select Macros

   4.      Click and drag your custom macro from the Commands tab to one of your toolbars

   5.      With the Customize dialog box still open, right-click the new macro button on your toolbar and choose Change Button Image from the Shortcut menu

   6.      Select an image

   7.      To display the macro as solely an image on your toolbar, right-click the macro button on your toolbar again, this time choosing Default Style from the Shortcut menu

   8.      Click Close

Now, just click your new macro button on your toolbar to run the macro.