I use passwords to protect worksheets (leaving cells unprotected in
which data is to be entered) and so I do not forget the password, I
write the password in the last row of the last column (IV65536) then I
protect the sheet.
When the sheet is protected I then cannot use the cusor keys or rather
the up/down/left/right arrow keys do not move the cell focus to the
next cell of the unprotected cells. I can mouse click on the cell but
that is a pain and I should be able to use the cursor keys. If I then
delete the data in the last column/row I am still stuck with the
problem. Is this an undocumented feature of excel??????
On other spreadsheets I have protected without using the last
column/row the cursor keys work fine.
--
Skypilot
------------------------------------------------------------------------
Skypilot's Profile:
http://www.excelforum.com/member.php...o&userid=19946
View this thread:
http://www.excelforum.com/showthread...hreadid=345710