O'Reilly logo

Office 2013 In Depth by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Editing Recorded Macros

As already mentioned in the previous section, macros can be accessed via the Macros dialog box. The Macros dialog box also enables you to open a macro in the VBA editor.

Although it isn’t exactly editing, you can delete unwanted macros from the list. To delete a macro from the Macros dialog box, select a macro and then click Delete. A message box opens and asks whether you want to remove the selected macro; click Yes to confirm the deletion.

Exploring the VBA Editor

To view the VBA code in a macro and edit it, you need to open the VBA editor. Select a macro in the Macros dialog box and then click Edit. The VBA Editor opens, as shown in Figure B.8.

Figure B.8. The VBA Editor.

The VBA editor window shown in Figure B.8 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required