Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 23

Macros are stored in a workbook. Even though you work with macros in the Visual Basic Editor, the code is stored in the same file with all the worksheets, cells, shapes, or whatever else you have inside your workbook. This makes macros very easy to distribute. You simply send someone the Excel file and the macros are included.

All macros need an event to start them running. Earlier in this chapter, I discussed assigning a shortcut key to a macro you record. Pressing the shortcut key is one type of event that can trigger a macro. In this section, I discuss the Personal Macro Workbook, a special workbook for storing macros, and a few common ways to trigger macros.