Page 78 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

Figure 4-7. The General tab of the Options dialog box contains the controls that don’t fit
well into the other tab pages in the dialog box.
Selecting the Collapse Proj. Hides Windows option will automatically close module and user
form windows when the project is collapsed in the Project Explorer window. Selecting the
Notify Before State Loss option informs you when performing a specific action will reset
all variables.
There are three options available for Error Trapping. Selecting the Break on All Errors option
will force the Visual Basic Editor to enter Break mode on all errors, regardless of whether
there are any error traps within the running procedures; selecting Break in Class Module will
enter Break mode on an untrapped error, highlighting the line of code within the class mod­
ule that produced the error; and selecting Break on Unhandled Errors will enter Break mode
only if there is no error handler active. If the untrapped error occurred within a class module,
Chapter 4
the line of code within the calling procedure is highlighted instead of the code within the class
module.
The last two options available on the General tab specify when the procedures are compiled.
For fastest execution, both Compile on Demand and Background Compile should be
selected. The first option allows faster application execution by compiling code on the fly
rather than all at once, and the second determines if idle processing time is used to finish
compiling the project during run-time mode.
The fourth and final tab available in the Options dialog lets you specify whether any of the
ancillary windows within the Visual Basic Editor are dockable. By default, all windows are
dockable with the exception of the Object Browser window.

52
Part 2: Visual Basic for Applications