View Single Post
  #3   Report Post  
Skypilot
 
Posts: n/a
Default


Peter,

Thanks but that is not the case - in other protected sheets I can use
the cursor keys to move between cells - the TAB key does not move
between the cells either - the only way is is to use the mouse to
select the unlocked cells. I think the significant factor is that I
have placed data at some stage in the last cell of the last row in the
last column. Try it - open a new spreadsheet select some cells then
format cells/protection and untick LOCKED - go to AV65536 and put in
some data then protect sheet - now try and move around the unlocked
cells with the cursor keys or the tab keys. do the same on a new sheet
except do not put data in AV65536 - protect sheet and you can move
around with cursor and TAB keys.


--
Skypilot
------------------------------------------------------------------------
Skypilot's Profile: http://www.excelforum.com/member.php...o&userid=19946
View this thread: http://www.excelforum.com/showthread...hreadid=345710