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