Workbooks

One of the most common Excel objects is a workbook. Everything that you do in Excel takes place in a workbook, which is stored in a file that, by default, has an XLS extension. An Excel workbook can hold any number of sheets (limited only by memory). There are four types of sheets:

♦ Worksheets

♦ XLM macro sheets (obsolete, but still supported)

♦ Dialog sheets (obsolete, but still supported)

You can open as many workbooks as you like (each in its own window), but at any given time, only one workbook is the active workbook. Similarly, only one sheet in a workbook is the active sheet. To activate a sheet, click its sheet tab, which is located at the bottom of the screen. To change a sheet's name, double-click the tab and enter the new text. Right-clicking a tab brings up a shortcut menu.

Beginning with Excel 2002, you can color-code the sheet tabs in a workbook. To do so, choose Format ^ Sheet ^ Tab Color. Color-coding sheet tabs may help identify a particular sheet, especially when the workbook has many sheets.

Where Are the VBA Module Sheets?

VBA first appeared in Excel 5. In this version (as well as in Excel 95), a VBA module appeared in a workbook as a separate sheet. A VBA module, as you may know, holds VBA code. Beginning with Excel 97, VBA modules no longer appear as separate sheets. Rather, you work with VBA modules in the Visual Basic Editor (VBE). To view or edit a VBA module, activate the VBE by pressing Alt+F11. Subsequent chapters discuss VBA modules in depth.

You can also hide the window that contains a workbook by using the Window ^ Hide command. A hidden workbook window remains open, but it is not visible.

Was this article helpful?

0 0

Post a comment