View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
y_not
 
Posts: n/a
Default Is it possible to set the enter and arrow keys to skip locked cel


When you go to
ToolsProtectionProtect sheet
Uncheck the option to "Select locked cells"
This forces the cursor from one unlocked cell to the next unlocked
cell.

I think this is what your after


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=523831