Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using TAB vs ENTER for data entry in a protected sheet
Hello experts,
We made a simple form using the lock/unlock function. Then, we protected the sheet (to only select unlocked cells). When using the TAB key, the cursor moves in the appropriate order and to each unlocked cell. But, using the ENTER key, the cursor skips some of the unlocked cells and not in order. I double checked each cell and they are indeed unlocked. Also, in Tools/Options/Edit, the "Move selection after Enter" is checked and the "Down" direction is selected. Why will it not advance to each unlocked cell when using the ENTER key? We're using 2003. Thank you. MB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Allowing data entry in protected sheets | Excel Discussion (Misc queries) | |||
data entry and saves it to sheet 2 | New Users to Excel | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Protected Row-Oriented Data Entry | Excel Worksheet Functions |