Where do I write VBA programs in Excel 97?
In Excel 97, all VBA programming is done using the new Visual Basic Environment (VBE). This programming environment is completely separate from Excel and is common across all Office 97 applications. You can access the VBE from Excel 97 either by choosing Tools/Macro/Visual Basic Editor from the Excel menu or by pressing ALT-F11 on the keyboard. In Excel 97, all of the VBA code modules, forms and other objects associated with your workbook are now referred to as that workbook’s VB Project. Upon opening the VBE for the first time, you will see two windows: the Project Explorer and the Properties Window. The Project Explorer displays a tree view style list of all the VBA components in your project. At the top of the Project Explorer you will see three toolbar buttons. The left-most button is called Toggle Folders. This button toggles the Project Explorer view between showing each type of VB Project component in a separate folder (i.e. modules in one folder, Excel objects in another) and s
