Hello Steve,
On several attempts with two separate workbooks, it just went between A1:B1
(same machine and instance of Excel). I could select farther down using the
mouse, but when I hit enter, it returned to A1 and again moved only between
A1 and B1, I could not travel down the column without using the mouse. I
was on a new worksheet with all blank cells in each case.

So yes, I agree it is odd since that (locked/unlocked cells/sheet protection
with restrictions) has been a standard suggestion for the 10 years I have
been posting here.

--
Regards,
Tom Ogilvy

"steve_doc" wrote in message
...
Thats odd Tom
worked for me in xl2003 on both home and work computer.
I did initially have an issue with it working on blanks cell - but that
seems to have cleared up

Regards
Steve

"Tom Ogilvy" wrote:

Just a heads up -
While that has worked in earlier versions of excel, Interestingly, that
didn't work for me in xl2003 and was the reason I didn't suggest it -
hopefully it will work for your users.

--
Regards,
Tom Ogilvy

"KJP692" wrote:

Success!!! I knew there had to be a simple answer. Thanks so much!

Karen

"steve_doc" wrote:

Hi Karen

When protecting the sheet there is a number of check boxes that you
can
check/uncheck.

Ensure that Select locked cell is uncheck - then enter your password,
and
confirm in the next dialogue prompt

HTH





"KJP692" wrote:

I had left a question on 6/14 about having Excel 2003 automatically
do a
library checkout by having the user enter a book # in the first
column and
then the library card # in the second column....then upon "enter"
the cursor
would move to the next line at the first column (A2).

The answer I received suggested unlocking columns A and B and then
protect
the sheet. I think I did these steps properly, but perhaps not
because the
cursor just keeps going right. (I preset the cursor to move right
not down)

One thing I did notice is that in highlighting columns A and B the
cursor
did just what I wanted it to do....but one key stroke wrong and the
highlighting disappears.

Any suggestions??

Thanks,
Karen