If you need to make simple changes to a macro, you can do so using Microsoft Visual Basic for Applications (VBA). The steps below briefly describe how to do this. For most Excel users, however, it is easier to record a new macro than to edit an existing macro. To learn how to write and edit complicated macros, you should take a course on VBA.
To edit a macro in Microsoft Excel:
Microsoft Visual Basic for Applications is a powerful programming language that can be used to make major customizations to Microsoft Excel and other Microsoft Office applications. Editing code is far beyond the scope of this class, but it's fun to think about just how powerful Microsoft Excel is.