View Single Post
  #7   Report Post  
Synectica
 
Posts: n/a
Default

Please can you advise the official channel as we would be delighted to use
that and send a sample worksheet that illustrates the issue.

"Jim Rech" wrote:

I don't care for this characteristic either but fyi it is not a bug in MS
parlance. A bug is something that behaves differently than the design.
This does not.

Btw, this newsgroup is not an official channel to Microsoft so it's not an
effective way to request a patch.

--
Jim
"Synectica" wrote in message
...
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?