Move direction problem when protected

M

MillmanQ

I have a 5 sheet workbook in Excel 2002, sp3 that I have protected and
unprotected cells in each worksheet. Something happened recently that I can
not figure out . when I turn protection on for each worksheet all is fine
except in the first worksheet. The up, down, left and right move arrows keys
will now only move to the left or right and only in one row. There are
several rows and columns with unprotected cells and the direction keys work
fine when protected with "select protected cells and unprotected cells" is
checked but when only "select unprotected cells" is checked the problem
occurs.
 

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

Top