Читать книгу Excel Macros For Dummies онлайн

17 страница из 60

 You need to tweak the macros to fit your workbook. Many of the macros reference example sheet names and ranges that you may not have in your workbook. Be sure to replace references such as “Sheet 1” or Range (“A1”) with the sheet names and cell addresses you are working with in your own workbooks.

Part 1

IN THIS PART …

Build a foundation for your macro skills with fundamental macro recording concepts.

Get a solid understanding of the ground rules for using and distributing macros in Excel.

Explore Excel’s coding environment with a deep-dive of the Visual Basic Editor.

Explore how to leverage the Excel object model to start writing your own macros from scratch.

Understand the roles played by variables, events, and error handling in macro development.

Chapter 1

IN THIS CHAPTER

Choosing macros

Recording macros

Understanding macro security

Finding out where to store and how to run macros

Exploring macro examples

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.