Select Worksheet
The Select Worksheet function selects a worksheet in the report making it the visible worksheet when the workbook is opened.
Settings | |
|---|---|
Worksheet | The name of the worksheet to select. This can be a fixed name or a cell reference where the cell contains the name of the worksheet to select. |
Range | The range to select on the Worksheet specified. This can be left blank if it is not needed. |
Example
A monthly report workbook contains report worksheets for every day of the month as well as a Summary worksheet containing daily summaries. The daily report worksheets are updated every day. When a user views the monthly report workbook, the Summary worksheet should be selected.
In practice, the last updated sheet will be the one visible to the user when the workbook is opened which is not what is required. Use this function with:
Setting | Value |
|---|---|
Worksheet | Summary |
Range |