Microsoft Office Tutorials and References
In Depth Information
Figure 23-7: A Project window with two projects listed.
If you try to expand a project that is password protected, Excel prompts you to enter the password.
Every project expands to show at least one node called Microsoft Excel Objects . This node expands to show an
item for each worksheet and chart sheet in the workbook: Each sheet is considered an object, and ThisWork-
book represents the Workbook object. If the project has any VBA modules, the project listing also shows a
Modules node with the modules listed there. A project may also contain a node called Forms (which contains
UserForm objects) and a node called Class Modules (which contains Class Module objects). This topic focuses
exclusively on standard VBA modules and does not cover the objects contained in the Microsoft Excel Objects
node, UserForms node, or Class Modules node.
A project may have another node called References. This node contains a list of all ref-
erences that the project uses. You can add or remove References by choosing
Tools ⇒ References. Unlike other items listed in the Project window, Reference items
don't have an associated code module.
Renaming a project
By default, all projects are named VBAProject. In the Project window, the workbook name appears (in paren-
theses) next to the project name. For example, a project may appear as follows: