Modify an Existing Macro: MS Word

• by Carol Bratt on 20070221 @ 09:59PM EST | google it | send to friends
• Filed under Carol's Corner Office | (related terms: word, macro macros, copy, delete, visual basic)

Sometimes after you have recorded a macro, you can't remember the name or it doesn't do exactly what you wanted it to do or you want another macro that is almost the same.

Luckily, all of these things can be taken care of. You can change an existing macro by changing its name, making a copy of it, deleting it or changing the actions of the macro.

Macros are recorded in a programming language called Visual Basic for Applications (VBA). The VBA program can be changed to modify the action of the macro. The language may be confusing at first, but a closer look will show you that the code echoes the selections you made while recording the macro.

To delete a macro, follow the handy steps below:

1. Choose Tools | Macro | Macros.
    
2. Select the macro you wish to delete.
    
3. Click Delete.
    
4. Click Close.

You can make changes to an already existing macro by following the steps below:

1. Choose Tools | Macro | Macros.
    
2. Select the macro.
    
3. Click Edit.
4. Close the window.

The change is automatically saved.

Most often, it is easier to record the macro again from the beginning than modifying the Visual Basic code.

In my next article, I'll explain how to rename a macro and copy a macro.

(c) Carol Bratt, all rights reserved. Used with permission. Duplication is forbidden without express consent of author. Visit Carol's web site to learn more tips like this one!

Free eBook: The Windows 7 Guide: From Newbies to Pros. In this 46 page guide you will be introduced to Windows 7 and what it has to offer. It will teach you about the new taskbar, how to resolve software compatibility issues, how to customize Windows Aero, and explain what the Windows 7 Libraries are all about. Also included: a detailed list of what software is included in Windows 7, and how easy networking is with Windows 7 along with other topics. The advice within this guide will help new users become acquainted with Windows 7 and can also help those who are on the fence about purchasing Windows 7 decide if it would be a good idea. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.