• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 32. Creating and Working with VB... > Editing and Viewing the VBA Code

Editing and Viewing the VBA Code

If you encounter any undesirable traits or errors when you test a macro, you can edit the macro. To do so, you open the macro in the VBE, where you can make corrections, remove unnecessary steps, rename or copy the macro, or add instructions that you can’t record in Word. To open a macro for editing in the VBE, follow these steps:

1.
Choose Tools, Macro, Macros. The Macros dialog box opens.

2.
In the Macro Name list, select the name of the macro you want to edit. If the macro you’re looking for isn’t displayed, click the Macros In arrow, and select a different document or template in the list.

3.
Click Edit. The VBE appears, as shown in Figure 32-9.

Figure 32-9. The VBE shows you the VBA code used to run your macros. This macro shows code used to insert a logo graphic.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint