Editing Macros in the Visual Basic Editor
After recording a macro as described earlier in this chapter, you can simply run it as needed. But if you need to change the macro, you can open it in the Visual Basic Editor and edit it there, deleting or changing actions you've recorded or writing VBA code for taking other actions. In this section, we'll glance very briefly at the Visual Basic Editor and make one small improvement to the recorded macro.
Opening the Sample Macro in the Visual Basic Editor
You can open a macro in the Visual Basic Editor in several ways, but the easiest is by using the Macro dialog box. But if the macro is one you've stored in the Personal Macro Workbook, you must unhide the Personal Macro Workbook so that you can open ...
Get Learn Excel 2011 for Mac 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.
