Microsoft Office Tutorials and References
In Depth Information
After you type the name of your macro in the Macro Name box, click OK. You can now
perform the actions you want Excel to repeat later; when you’re done, in the Macros list,
click Stop Recording to add your macro to the list of macros available in your workbook.
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_start workbook located in your Chapter12
practice file folder to complete this exercise. Open the YearlySalesSummary_start
workbook, click the Enable Content button on the Message Bar (if necessary), and
save the workbook as YearlySalesSummary . Then follow the steps.
1. On the View tab, in the Macros group, click the Macros arrow and then, in the list
that appears, click Record Macro .
The Record Macro dialog box opens.
2. In the Macro name box, delete the existing name, and then type RemoveHighlight .
3. Click OK .
The Record Macro dialog box closes.