Macro Sheets Only
Equivalent to choosing the Options command from the tools menu and then selecting the Edit tab in the Options dialog box. Sets various worksheet editing options.
Syntax
OPTIONS.EDIT(incell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links, move_direction, autocomplete, animations)
OPTIONS.EDIT?(incell_edit, drag_drop, alert, entermove, fixed, decimals, copy_objects, update_links, move_direction, autocomplete, animations)
Incell_edit is a logical value corresponding to the Edit Directly In Cell check box, which if TRUE allows In Cell Editing. If FALSE, editing directly in cells is not allowed. If omitted, the dialog box setting is not changed.
Drag_drop is a logical value corresponding to the Allow Cell Drag And Drop check box, which if TRUE allows drag and dropping on sheets. If FALSE, drag and drop is not allowed. If omitted, the dialog box setting is not changed.
Alert is a logical value corresponding to the Alert Before Overwriting Cells check box, which if TRUE displays an alert message warning you that cells containing values are about to be overwritten. If FALSE, an alert will not be displayed if your cells are about to overwritten. If omitted, the dialog box setting is not changed.
Entermove is a logical value corresponding to the Move Selection After Enter check box, which if TRUE moves the selection after the ENTER key is pressed. If FALSE, the selection is not moved. If omitted, the dialog box setting is not changed.
Fixed is a logical value corresponding to the Fixed Decimal check box, which if TRUE fixes the decimal place according to decimals. If FALSE, the decimal places are not fixed. If omitted, the dialog box setting is not changed.
Decimals is a number specifing the number of decimal places. Decimals is ignored if fixed is FALSE or omitted.
Copy_objects is a logical value corresponding to the Cut, Copy, and Sort objects with Cells check box. If TRUE allows objects to be cut, copied and sorted with their cells. If FALSE, objects are not cut, copied or sorted with cells. If omitted, the dialog box setting is not changed.
Update_links is a logical value corresponding to the Ask to Update Automatic Links check box, which if TRUE will prompt the user when the workbook is opened that has links to other documents. If FALSE, the prompt will not be displayed. If omitted, the dialog box setting is not changed.
Move_direction is a number specifying the direction to move the selection when the ENTER key is pressed and Entermove is TRUE. Setting this number to 1 moves down one cell, 2 moves right one cell, 3 moves up on cell, and 4 moves down one cell..
Autocomplete is a logical value corresponding to the Enable Autocomplete for Cell Values check box, which if TRUE will enable the AutoComplete feature of Microsoft Excel for Windows '95.
Animations is a logical value corresponding to the Animate Insertion and Deletion check box, which if TRUE will enable the worksheet Animations feature of Microsoft Excel for Windows '95. Deleted worksheet rows and columns will slowly disappear, and inserted worksheet rows and columns will slowly appear.
Related Functions
OPTIONS.GENERAL Sets various general Microsoft Excel settings
List of Command-Equivalent Functions