The Visual Basic toolbar

Excel contains a Visual Basic toolbar that groups actions for manipulating macros. To view this toolbar choose View > Toolbars and select Visual Basic. The toolbar (see Figure 2.18) include buttons for the following:

Run Macro displays the Macros dialog box, in which any currently available macro can be selected to run.

Record Macro displays the Record Macro dialog box. Note that when the Visual Basic toolbar is on screen, the Record Macro button appears depressed; clicking can stop the macro.

Security Button displays the Security dialog box where you can select the security level. There are three levels from high - where macros are only accepted by the system from trusted sources, to protect against macro viruses, to low - with no protection. The default level is medium. Visual Basic Editor switches to the Visual Basic Editor - see Chapter 3. Control Toolbox toggles the display of the Control Toolbox toolbar. This lets you add controls such as buttons, edit boxes, and so on, to Excel worksheets.

Design Mode switches the current document to Design mode; it also displays the Control Toolbox. The Design mode button is another toggle button (toggling between Exit Design and Design mode).

Microsoft Script Editor activates an editor that enables the creation of HTML and XML pages.

Security

Control Toolbox

Script Editor

Record will display dialog Record Box

Visual Basic Editor switches to VBA editor

Run will display the Macro Dialog Box

Record will display dialog Record Box

Security

Visual Basic Editor switches to VBA editor

Control Toolbox

Design Mode

Script Editor

Figure2.18 The Visual Basic toolbar

0 0

Post a comment