View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AAS AAS is offline
external usenet poster
 
Posts: 24
Default how to prevent unlimited scrolling in unprotected cells

I have a set of unprotected cells in an otherwise protected worksheet.
Within this block of unprotected cells, there is no limit to the movement of
the cursor. if i hold down the left arrow, the cursor won't stop at column
A, it will jump to the last unprotected column of the previous row. same
thing happens if i hold down the down arrow, the cursor won't stop at the
bottom of the unprotected section but jumps to the top of the next colum.
how can I stop this from happening?