The main purpose of this Book is to help you work with the most basic tools and features that allow you to execute macros.
This Book has two main goals:
#1. Help you understand how to execute macros in practice. For these purposes, this Book shows you (step-by-step) the most common processes you follow to execute macros in Excel.
#2. Help you understand the rules and logic behind each of the most common processes you use to execute macros in Excel. This includes understanding, among others: (i) The main consequences of working with the different tools and features you can use to execute macros; (ii) The main criteria to determine which tool or feature to use when executing a macro; and (iii) The main rules and considerations to keep in mind when executing macros.
This Book is divided in six Chapters.
#1. Chapter 1 is an introduction to the topic of macro execution.
#2. In Chapter 2, you learn: (i) How to assign a keyboard shortcut to a macro; and (ii) How to change an existing macro keyboard shortcut.
#3. In Chapter 3, you learn how to assign macros to: (i) Form Controls, particularly Command Buttons; and (ii) Inserted objects, such as Text Boxes.
#4. In Chapter 4, you learn how to add buttons (from which you can execute macros) to both: (i) The Quick Access Toolbar; and (ii) The Ribbon.
#5. In Chapter 5, you learn how to execute a macro from the Macro dialog box.
#6. In Chapter 6, you learn how to execute a macro with the Run Sub/UserForm command of the Visual Basic Editor (VBE).