Defining Visual Basic for Applications macros

The Visual Basic for Applications Macros window enables you to run, edit, or delete a macro.

About this task

To open the Macros window, use the Visual Basic for Applications toolbar shortcut or select Tools > Visual Basic for Applications > Macros and use these selections as needed:

The window contains the following buttons:

To run a macro, highlight a macro in the Macro box, then click Run.

To edit a macro, highlight the macro in the Macro box, then click Edit.

To create a macro, type in a new name in the Macro Name field, then click Create.

Note: Since Visual Basic for Applications macros are contained in modules, you must first create a module before creating your first macro. If you have not yet created a module, the Create button is disabled. Modules cannot be created from the Macros window. You must open the Visual Basic for Applications IDE to do so.

To delete a macro, highlight a macro in the Macro box, then click Delete.

IBM® Rational® Rhapsody® Visual Basic for Applications macros are saved automatically with your project. When you load the project again, the macros you created are available.


Feedback