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 ...
Get Office 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
