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

When you’re working in the VBE, each Excel workbook and add-in that’s open is a project. You can think of a project as a collection of objects arranged as an outline. You can expand a project by clicking the plus sign (+) at the left of the project’s name in the Project Explorer. Collapse a project by clicking the minus sign (-) to the left of a project’s name. Or, you can double-click the items to expand and collapse them.

Figure 2-2 shows the Project Explorer with two projects listed: a workbook named Book1 and a workbook named Book2.

FIGURE 2-2: The Project Explorer with two projects open, expanded to show their objects.

Every project expands to show at least one folder called Microsoft Excel Objects. This folder expands to show an item for each sheet in the workbook (each sheet is considered an object), and another object called ThisWorkbook (that represents the Workbook object). If the project has any VBA modules, the project listing also shows a Modules folder.