ENTER.DATA
Macro Sheets Only
Turns on Data Entry mode and allows you to select and to enter data into the unlocked cells in the current selection only (the data entry area). Use ENTER.DATA when you want to enter data only in a specific part of your sheet. You can then use that part of the sheet as a simple data form.
Syntax
ENTER.DATA(logical)
Logical is a logical value that turns Data Entry mode on or off.
- If logical is TRUE, Data Entry mode is turned on; if FALSE, Data Entry mode is turned off and data entry, cell movement, and cell selection return to normal. If logical is omitted, ENTER.DATA toggles Data Entry mode.
- Logical can also be the number 2. This setting turns on Data Entry mode and prevents the ESC key from turning it off.
- Logical can also be a reference. Using a reference for this argument turns on Data Entry mode for the supplied reference.
Remarks
Tips
- Normally you use Data Entry mode to enter data, but you can also prevent someone from entering data or moving the active cell by locking all the cells in the current selection before turning on Data Entry mode. This is useful if you want a user to view a range of cells but not change it or move the active cell. Similarly, if you unlock certain cells, you can restrict the user's movement to the Data Entry area only.
- To prevent someone from activating another workbook, which would turn off Data Entry mode, use the ON.WINDOW function or an Auto_Deactivate macro.
Related Function
DISABLE.INPUT Blocks all input to Microsoft Excel
FORMULA Enters values into a cell or range or onto a chart
List of Command-Equivalent Functions