Читать книгу Excel Macros For Dummies - Alexander Michael - Страница 4

IN THIS CHAPTER

❯❯ Why use macros

❯❯ Recording macros

❯❯ Understanding macro security

❯❯ Examples of 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. You first manually dial and save a number. Then when you want, you can redial those numbers with the touch of a button. Just as on a cell phone, you can record your actions in Excel while you perform them. While you record, Excel gets busy in the background, translating your keystrokes and mouse clicks to written code (also known as Visual Basic for Applications (VBA)). After a macro is recorded, you can play back those actions anytime you want.

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