To edit a macro, you need to open it in the editor. There are two ways to locate a macro in the editor:
From the Tools menu, select Macro and then Macros.
When the Macros dialog box appears, select the desired macro and click the Edit button to start the Visual Basic Editor.
The second way involves opening the editor and navigating to the desired macro.
Open the editor as described in FAQ 11.13.
Either manually scroll to the desired macro or select it from the combo box in the upper-right corner of the editor.
When you've located the macro, you can simply type in the desired code, save your changes, and then close the editor.