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
Deleting A Macro
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