Editing Macros

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:

On the VIEW tab, in the Macros group, click the Macros command:

Click View Macros:

In the Macro dialog box, choose the macro you want to change and click Edit to open the macro in the Microsoft Visual Basic for Applications window:

You can see and edit your code in the Microsoft Visual Basic for Applications window:

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.