OPTIONS.TRANSITION

Macro Sheets Only

Equivalent to choosing the Options command from the Tools menu and then selecting the Transition tab in the Options dialog box. Sets options relating to compatibility with other spreadsheets.

Syntax

OPTIONS.TRANSITION(menu_key, menu_key_action, nav_keys, trans_eval, trans_entry )
OPTIONS.TRANSITION?(menu_key, menu_key_action, nav_keys, trans_eval, trans_entry )

Menu_key is text specifying which alternate menu key to use.

Menu_key_action is the number 1 or 2 specifying options for the alternate menu or Help key. In Microsoft Excel for the Macintosh, menu_key_action is ignored.

Menu_key_action Alternate menu or Help key activates

1 or omitted Microsoft Excel menus

2 Lotus 1-2-3 Help

Nav_keys is a logical value that corresponds to the Transition Navigation Keys check box, which if TRUE uses alternate navigation keys that correspond to the navigation keys for Lotus 1-2-3. In Microsoft Excel for the Macintosh, nav_keys is ignored.

Trans_eval is a logical value that corresponds to the Transition Formula Evaluation check box.

Related Functions

OPTIONS.LISTS.DELETE Deletes a custom list

OPTIONS.LISTS.GET Returns contents of custom AutoFill lists

OPTIONS.VIEW Sets various view settings

List of Command-Equivalent Functions