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