navigation keys in protected sheet

V

VaBuckshot

I have two workbooks with three sheets in both. Each sheet is protected. In
one workbook, the second and third sheet do not allow any navigational
keys--such as ENTER or Down arrow--to work vertically. The TAB will move
horizontally from cell to cell but will not go to next line. In the second
workbook, all navigational keys work fine when sheets are protected. The
workbooks were created at same time in same manner on same computer with same
settings. What is wrong?
 
K

Kevin B

When you protect a sheet in Excel 2003 you can cherry pick what the user can
do in terms of navigation and editing. It sounds like the sheet that only
allows TAB as a navigation key has SELECT LOCKED CELLS option turned off.

Click TOOLS and UNPROTECT the document, and then reprotect the document and
in the ALLOW USERS OF THIS WORKSHEET list, turn SELECT LOCKED CELLS on.
 

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

Ctl Page Up and Ctl Page Down work selectively 4
navigational keys in protected sheets 0
ENTER skips unlocked cells 3
cannot tab to next unlocked cell 0
Move direction problem when protected 0
protecting sheets 2
Text boxes move on protected worksheet 3
Shared Workbooks & Code 1

Top