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

Open the Office Menu

Choose Excel Options

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

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