Before you try to edit a macro, you should be familiar with the Visual Basic Editor. This doesn’t mean you need to know how to write Visual Basic script and this certainly isn’t a Visual Basic course, but it will help you out tremendously if you can, at the very least, read the language.
So, before you edit your first macro, take a few minutes to review the parts of a macro as seen through the eyes of Visual Basic. We’ll use the contents of a simple macro that contains all the parts we need to learn how to read this script.
Figure 32. Visual Basic Macro Editor
Editing a Macro
Choose Tools: Macro: Macros… from the Menu bar
Select the macro you want to edit