AX2259

Setting the active sheet and active cell

You can specify the active sheet for an Axiom file, so that the file will always open to the designated sheet. Additionally, for each sheet you can specify the active cell, so that the cursor will always start in the same place when the file is opened.

Both of these settings can only be made on the Control Sheet.

Setting the active sheet

To set the active sheet for a file, use the Activate sheet on open option, located in the Workbook Options section of the Control Sheet. Enter the name of any visible sheet in the file.

When the file is opened, the sheet designated here will be the active sheet, regardless of which sheet was active when the file was last saved. This option is useful to keep the active sheet consistent for end users, rather than accidentally set it to whatever sheet the file designer is working on.

If this setting is left blank, then the file will open to whichever sheet was active when the file was last saved.

NOTE: If special features are used to open the file to a specific sheet—such as the GetDocument function, or an alert notification—then that designated sheet takes precedence over the active sheet defined in the Control Sheet.

Setting the active cell

To set the active cell for a sheet, use the Active Cell option, located in the Sheet Options section of the Control Sheet. Enter the desired cell address, such as F24.

When the file is opened, the specified cell is made active on that sheet. This means that the cursor is placed in this cell, and the sheet is re-oriented so that this cell is positioned in the top left-hand corner (after honoring any freeze panes settings).

This option is useful for any file where you want the user to start at a certain place in the sheet, and you do not want the active cell to be inadvertently left on whichever cell was active when the file was last saved.