Page 311 - Excel Workbook for Dummies

33_798452 ch23.qxp 3/13/06 7:51 PM Page 294
294 Part VII: Macros and Visual Basic for Applications

Figure 23-1:
You can
use the but- Control Toolbox
tons on the Record Macro Design Mode
Visual Basic
toolbar to
record or
run a macro
as well as Microsoft Script Editor
to open
the Visual Visual Basic Editor
Basic Editor.
Run Macro

Figure 23-2 shows the arrangement of the typical components of the Visual Basic
Editor when you first open it. As you can see, this window contains its own menu
bar with a few more menus than the regular Excel window. Beneath the menu bar,
you find a Visual Basic Editor Standard toolbar. This toolbar, shown in Figure 23-3
with the names of its buttons called out, contains a number of buttons familiar to
you from the Standard toolbar in the regular Excel window.

Beneath the Standard toolbar in the Visual Basic Editor, you find a number of tiled
windows of various sizes and shapes. Keep in mind that these are the default win-
dows and their default arrangement. They are not the only windows that you can
have open in the Visual Basic Editor (as though it weren’t crowded and confusing
enough as is), and this is not the only way that they can be arranged.

Project Explorer

Figure 23-2:
The Visual
Basic Editor
window as it
normally
appears
when first
opened.

Properties window Code window