Learn Excel 2011 for Mac

Understanding Your Options for Automating Tasks

With Excel 2011 on Mac OS X, you can automate tasks in several ways

• Create macros. A macro is a sequence of commands that you can run all at once. The easy way to create a macro is to record it by turning on the Macro Recorder and performing the actions you want the macro to repeat; when you turn the Macro Recorder off, you have a macro that you can run again. You can also write macros from scratch by working in the Visual Basic Editor application. Or you can record macros and then use the Visual Basic Editor to edit out unwanted commands or to add other commands. This chapter shows you how to record macros and edit them in the Visual Basic Editor.
• Use Automator. The Automator application, which ...