Editing Macros

Welcome to our free Advanced Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Advanced Microsoft Excel 2013 Training course.

Contact Us or call 1-877-932-8228
Editing Macros

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:

  1. On the VIEW tab, in the Macros group, click the Macros command:Macros Command
  2. Click View Macros:View Macros Command
  3. 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:Macro Dialog Box
  4. You can see and edit your code in the Microsoft Visual Basic for Applications window:Code

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.

Next

This tutorial is based on Webucator's Advanced Microsoft Excel 2013 Training Course. We also offer many other Microsoft Excel Training courses. Sign up today to get help from a live instructor.