Chapter 1
Recording and Running Macros
IN THIS CHAPTER
Understanding how macros do what they do
Recording macros for instant playback
Using the relative option when recording macros
Running the macros you’ve recorded
Changing the macro security settings
Assigning your macros to the Ribbon and Quick Access toolbar
Macros enable you to automate almost any task that you can undertake in Excel. By using Excel’s macro recorder to record tasks that you perform routinely, you not only complete tasks considerably faster (because Excel can play back your keystrokes and mouse actions much faster than you can perform them manually), but you are also assured that each step is carried out the same way every time you perform the task.
Excel’s macro recorder records all the commands and keystrokes that you make in a language called Visual Basic for Applications (VBA), which is a special version ...
Get Excel All-in-One For Dummies 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.
