vba Workbooks

he most common Excel object 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 XLSX extension. An Excel workbook
can hold any number of sheets (limited only by memory). There are four types of sheets:
h Worksheets
h Chart sheets
h Excel 4.0 XLM macro sheets (obsolete, but still supported)
h Excel 5.0 dialog sheets (obsolete, but still supported)
You can open or create 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 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 with additional options for the sheet, including changing its tab color, hiding the sheet,
and so on.
You can also hide the window that contains a workbook by using the View➜Window➜Hide command. A hidden workbook window remains open, but it isn’t visible to the user. Use the
View➜Window➜Unhide command to make the window visible again. A single workbook can display in multiple windows (choose View➜Window➜New Window). Each window can display a
different sheet or a different area of the same sheet.