Microsoft Office Tutorials and References
In Depth Information
Recording Your First Macro
Figure 13-4: Start recording a new macro called RemoveDataBars.
3. Highlight cells C1:C21.
4. Go to the Home tab and select Conditional Formatting ➜ Clear Rules ➜ Clear Rules from
5. Go to the Developer tab and click the Stop Recording command.
Excel stops recording.
You now have a new macro that removes conditional formatting rules from cells C1:C21.
Running your macros
To see your macros in action, follow these steps:
1. Select the Macros command from the Developer tab.
The dialog box in Figure 13-5 activates, allowing you to select the macro you want to run.
2. Select the AddDataBars macro.
3. Click the Run button.
Figure 13-5: Use the Macro dialog box to select a macro and run it.