O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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 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 ...

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