OK, this is a really picayune question, and certainly not "mission critical," but if anyone knows the answer I'd like to know....

I have a spreadsheet with 4 data-entry cells, plus several checkboxes (to select a 5th value). When I protect the sheet (and don't allow users to select locked cells), the selection automatically advances (when a value is entered) from the current cell to the "next" unlocked cell, even though the "move cursor after data entry" option is turned OFF. I understand that this is probably intended as a "helpful" function (and normally, it is). BUT in this case, when a value is entered in the last data-entry cell, I do NOT want the selection to jump (back to the first cell). I want that same cell to remain selected.

Is there any simple way to disable the "selection jump" (or whatever you call it), either for this one cell, or for the whole sheet / file? I know I can write a WorksheetChange event macro that reselects that cell (if it is the Target). Just wondering if there's some easier way, that I'm unaware of. Thanks!