Cursor moves after enter, when it should not

  • Thread starter Thread starter jss87
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Moving a bunch of data 1
Move to next unprotected cell 6
Protection causes unwanted cursor movement 5
cursor movement within a sheet 9
Cursor Behavior Changed 4
Move selection after Enter Direction 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top