View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MB MB is offline
external usenet poster
 
Posts: 53
Default Using TAB vs ENTER for data entry in a protected sheet

Hello experts,

We made a simple form using the lock/unlock function. Then, we protected
the sheet (to only select unlocked cells). When using the TAB key, the
cursor moves in the appropriate order and to each unlocked cell. But, using
the ENTER key, the cursor skips some of the unlocked cells and not in order.

I double checked each cell and they are indeed unlocked. Also, in
Tools/Options/Edit, the "Move selection after Enter" is checked and the
"Down" direction is selected.

Why will it not advance to each unlocked cell when using the ENTER key?

We're using 2003.

Thank you.
MB