Cursor moves after enter, when it should not

J

jss87

Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for
"move cursor after enter". Normally this is fine, but I made a sheet with a
few protected cells and now it moves to the next unprotected cell, in
whatever direction is greyed out. I don't often protect cells, so I don't
remember if older versions worked correctly.

I'm doing a sort of manual optimization and I want to see the effects of
change, maybe try a different value in the same cell, or go to a cell of my
choosing, not Excels.
 
G

glenton (glenton

You'll have to unprotect your sheet, and then reprotect it, checking the box
labelled "Select locked cells". Of course you can then select any cell in
your worksheet.

It's a funny bug, which I don't think existed in previous versions, because
they never used to have the select locked cells option in the protection menu.

All the best

Glenton
www.leviqqio.com
 
Top