• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 29. Introducing VBA Programming > Using the Project Explorer

Using the Project Explorer

The VBE Project Explorer works like a table of contents for any VBA projects you have open. You can use it to quickly gain access to the modules and procedures you need to view and edit. You also can use the Project Explorer to copy and move modules among projects, or to delete modules from projects. As its name implies, the Project Explorer looks and works much like the Windows Explorer.

The Project Explorer lets you work with any projects that are currently open. Because each workbook in Excel contains a project, the Explorer shows a project for each open workbook. This includes any hidden workbooks, such as the Personal.xls workbook that you can create when you record a macro with the macro recorder. Figure 29.2 shows the Project Explorer as it might appear with two open workbooks, along with the Personal.xls hidden workbook.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint