Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

Chapter 1

Macro Fundamentals

In This Chapter

arrow Understanding why you should use macros

arrow Recording macros

arrow Understanding macro security

arrow Seeing macros in action

A macro is essentially a set of instructions or code that you create to tell Excel to execute any number of actions. In Excel, macros can be written or recorded. The key word here is recorded.

Recording a macro is like programming a phone number into your cell phone. On your phone, you first manually dial and save the number. Later, you can redial those numbers with the touch of a button. In Excel, you start recording a macro, and then you perform your intended actions. While you record, Excel gets busy in the background, translating your keystrokes and mouse clicks to a macro. This written code is known as Visual Basic for Applications (VBA). After the macro is recorded, you can play back those actions anytime you want.

In this chapter, you explore macros and learn how you can use them to automate recurring processes to simplify your life.

Why Use a Macro?

The first step in using macros is admitting you have a problem. Actually, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346