Microsoft Office Tutorials and References
In Depth Information
Introducing the Visual Basic Editor
This topic focuses exclusively on VBA modules, also known as standard modules, which
is where Excel stores custom worksheet functions.
Minimizing and maximizing windows
At any given time, the VB Editor may have lots of code windows. Figure 22-9 shows an example.
Figure 22-9: Code window overload.
Code windows are much like worksheet windows in Excel. You can minimize them, maximize
them, hide them, rearrange them, and so on. Most people find that it’s much easier to maximize
the code window that they’re working on. Sometimes, however, you may want to have two or
more code windows visible. For example, you may want to compare the code in two modules or
copy code from one module to another.
Minimizing a code window gets it out of the way. You also can click the Close button in a code
window’s title bar to close the window completely. To open it again, just double-click the
appropriate object in the Project window.
You can’t close a workbook from the VB Editor. You must reactivate Excel and close it from