In Excel 5 and Excel 95, a Visual Basic for Applications (VBA) module appeared as a separate sheet in a workbook. Beginning with Excel 97, VBA modules no longer show up as sheets in a workbook. Rather, you use the Visual Basic Editor (VBE) to view and work with VBA modules.

VBA modules are still stored with workbook files; they just aren't visible unless you activate the VBE.

The VBE is a separate application that works seamlessly with Excel. Seamlessly, meaning that Excel takes care of the details of opening the VBE when you need it. You can't run VBE separately; Excel 2000 must be running in order for the VBE to run.

When you're working in Excel 2000, you can use any of the following techniques to switch to the VBE:

• Press Alt+F11.
• Select Tools, Macro, Visual Basic Editor.
• Click the Visual Basic Editor button, which is located on the Visual Basic toolbar.

Don't confuse the Visual Basic Editor with the Microsoft Script Editor. These are two entirely different animals. The Script Editor is used to edit HTML scripts written in VBScript or JavaScript.