Editing a Macro

Even if a macro works correctly, you may sometimes find that you want to change the way it runs or the steps it contains. To do so, you can edit the existing code ”the list of instructions Excel recorded when you turned on the macro recorder. As you recorded the macro steps, Excel kept track of each action in a separate location called a Module sheet. You can edit macro code by opening its Module sheet and using the keyboard to make changes just as you would to a word processing document. You can use the Delete and Backspace keys to remove characters and then type the corrections.

Edit a Macro

Click the Tools menu, point to Macro, and then click Macros.

Click the macro you want to edit.

Click Edit.

Select the text to be edited, and then make the necessary corrections.

When you're done, click the File menu, and then click Close And Return To Microsoft Office Excel.