Читать книгу Excel Macros For Dummies - Dick Kusleika - Страница 34

Working in the Visual Basic Editor

Оглавление

The VBE is actually a separate application that runs when you open Excel. To see this hidden VBE environment, you need to activate it. With Excel open, one of these two ways does the trick:

 Press Alt+F11.

 Click the Visual Basic button on the Ribbon’s Developer tab.

To return to Excel, press Alt+F11 or click the Close button in the VBE.

Figure 2-1 shows the VBE with the key parts identified. Chances are your VBE program window won’t look exactly like what’s shown in Figure 2-1. The VBE contains several windows and is highly customizable. You can hide windows, rearrange windows, dock windows to the main window, and so on.


FIGURE 2-1: The VBE with significant elements identified.

Excel Macros For Dummies

Подняться наверх