List of sheets
A list of sheets in the workbook is produced by the AutoDocumentation List Sheets command. The list is on sheet X~Sheets. The contents of the list are as follows:
- Index
- The order in which the sheets appear in the workbook.
- Sheet
- The name of the sheet.
- If the sheet is a worksheet, and is not hidden, the entry in this column is a hyperlink; clicking on it will take you to cell A1 of the worksheet in question.
- Type
- Whether the sheet is a Worksheet, Chart sheet, International Macro Sheet, Macro Sheet, DialogSheet, or Module. Note that the latter four types of sheet are not commonly used in Excel 97 or later, but they may appear in workbooks originally developed with earlier versions of Excel.
- Hidden?
- Whether the sheet is hidden, Yes or No. Invisible means that the sheet is not accessible to the user (technically, it has visibility xlVeryHidden which can be changed only through VBA code).
- Contents Protected?
- Whether the contents of the sheet are protected, Yes or No, ie whether you are prevented from editing locked cells.
- Objects Protected?
- Whether the drawing objects on the sheet are protected, Yes or No.
- Used Range
- For worksheets and macro sheets, the smallest rectangle that contains all the cells that are used.
- Description
- A description of the sheet. This is taken from the contents of the cell A1 on the sheet if it is a worksheet. The description of a chart sheet is the title of the chart. The description of a dialog sheet is the title of the dialog.
Updating the list
The list of sheets can be updated at any time by using the command XLSior > AutoDocument > List Sheets.
It is updated automatically whenever XLSior adds a new sheet to your workbook, or changes the order of the sheets.
Sorting the list
The order in which the sheets appear in the list is determined by your user and workbook preferences.