Page 75 - Microsoft Office Excel 2003 Programming Inside Out

VBA Programming Starter Kit

Customizing the Visual Basic Editor
The Visual Basic Editor is fully customizable and can be configured to fit your own personal
work style. The various windows can be undocked from their default positions and placed
anywhere on the screen, including along a different edge of the window. Also, as discussed in
Chapter 3, you can move, hide, and display any of the available toolbars, in addition to add­
ing or removing toolbar buttons from any toolbar.

All of the ancillary windows within the Visual Basic Editor have a default docked location. To
move a window, place the mouse pointer inside the title bar for the window and drag it to its
desired location. An outline box will appear to show you where the window will be located
when you release the mouse, as shown in Figure 4-4.

Chapter 4

Figure 4-4. The default locations for the windows in the Visual Basic Editor appear here, but
you can move the windows around to optimize your working environment.

Tip A quick way to swap between a docked window and the last undocked position is to
double-click the Title bar of the window. This trick is especially handy when trying to return
to the docked position because it can be hard at times to get the Visual Basic Editor to
recognize that you want to return the window to a docked position.

Customizing the toolbars requires the same procedures as in other Windows-based applica­
tions. To move a toolbar, simply click within a blank area of the toolbar and drag it to the
desired location. Click the Toolbar Options button (located in the lower right corner of the
toolbar) or right-click a blank area of the toolbar and click Customize to display the Customize
dialog box, from which you can add or remove buttons from the visible toolbars. By right-
clicking any of the toolbars, you can also show or hide any available toolbar.

49
Part 2: Visual Basic for Applications