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

Excel 2007: Create a Macro

Excel 2007: Create a Macro

Macros are terrific for automating repetitive tasks. And, since it’s definitely a feature that can save you time, you might as well use it.

If you’ve already started looking on the Ribbon for the Record Macro command, you won’t find it. It’s not a command that a lot of people use and macros can be potentially dangerous when created by people with malicious intent.

As a result, you have to dig a little bit to find the Macro command.

Showing the Developer Tab

     
  1. Open the Office Menu
     
  2.  
  3. Choose Excel Options
     
  4.  
  5. On the Popular tab, check Show Developer tab in the Ribbon
     

Now, you’re ready to record a macro.  

Recording and Deleting Macro

Recording A Macro

     
  1.  Click the Record Macro command in the Code group on the Developer tab
     

Figure 42. Record Macro Dialog Box

    2.       Enter a name for your macro in the Macro name box
(Macro names MUST being with a letter and they can’t contain any spaces)

    3.       Assign a shortcut key, if desired
(Be careful to NOT assign any shortcut key you currently use for another function. The macro will ALWAYS override any default shortcut keys)

    4.       Under Store macro in, choose the location for your new macro

    5.       Enter a brief Description of your macro

    6.       Click OK

    7.       YOUR MACRO IS NOW RECORDING

    8.       Perform the actions you want the macro to repeat on command

    9.        When finished, click the Stop Recording command in the Code group on the Developer tab

Deleting A Macro

     
  1.  Click the Macros command in the Code group on the Developer tab
     

Figure 43. Macro Dialog Box

    2.       Select the macro you want to delete

    3.       Click Delete