navigation keys in protected sheet
 

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?

navigation keys in protected sheet
 

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.
--
Kevin Backmann


"VaBuckshot" wrote:

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?