Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
Allow unprotected cells to spell check after sheet is protected | Excel Worksheet Functions | |||
Grouping in a protected sheet | Excel Discussion (Misc queries) |