View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
KJP692 KJP692 is offline
external usenet poster
 
Posts: 10
Default re-asking for help

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