Microsoft Office Tutorials and References
In Depth Information
Creating and modifying macros
After you enter the name of your macro in the Macro Name box, click OK. You can now
perform the actions that you want Excel to repeat later; when you’re done recording your
macro, in the Macros list, click Stop Recording to add your macro to the list of macros
available in your workbook.
TIP The Record and Stop Recording icons also appear on the status bar.
To modify an existing macro, you can simply delete the macro and re-record it. Or if you
just need to make a quick change, you can open it in the Visual Basic Editor and add to or
change the macro’s instructions. To delete a macro, open the Macro dialog box, click the
macro you want to delete, and then click Delete.
SEE ALSO For more information about using the Visual Basic Editor, press Alt+F11 to display
the Visual Basic Editor, and then press F1 to display the Visual Basic Help dialog box.
In this exercise, you’ll record, edit, save, and run a macro that removes the bold formatting
from selected cells.
SET UP You need the YearlySalesSummary workbook located in the Chapter12
practice file folder to complete this exercise. Open the workbook, click the Enable Content
button on the Message Bar (if necessary), and then follow the steps.
On the View tab, in the Macros group, click the Macros arrow and then, in the list
that appears, click Record Macro to open the Record Macro dialog box.
In the Macro name box, replace the existing name with RemoveHighlight .
Click OK to close the Record Macro dialog box.
Select the cell range C4:C7 . (The text in these cells is currently bold.)
On the Home tab, in the Font group, click the Bold button to remove the bold
On the View tab, in the Macros list, click Stop Recording to stop recording the macro.
In the Macros list, click View Macros to open the Macro dialog box.
In the Macro name area, click RemoveHighlight , and then click Edit to display the
macro in the Visual Basic Editor.