OPTIONS.TRANSITION macro

Equivalent to clicking the Options command on the Tools menu and then clicking 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.

Trans_entry    is a logical value that corresponds to the Transition Formula Entry 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

Return to index