In the Excel applications we build for others it is useful to have the cell
selection remain on the cell after the data in it is modified. This is done
by unchecking "Move Selection after Enter" on the "Edit" tab of the
"Options" dialogue. However, when protecting the worksheet to allow
selection of unlocked cells only, the cell selection then ignores the Edit
tab setting and moves in the default direction after Enter. If worksheet
protection is modified to also allow selection of locked cells, then the cell
selection will obey the Edit setting and not move after Enter. This is
surely a bug in Excel... It is very frustrating as either we must allow the
selection move to other unlocked cells after Enter, or permit selection of
locked cells - neither of which is really satisfactory. Can Microsoft please
fix this and send us a patch?