| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to set the enter and arrow keys to skip locked cel
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to set the enter and arrow keys to skip locked cel
When you go to ToolsProtectionProtect sheet Uncheck the option to "Select locked cells" This forces the cursor from one unlocked cell to the next unlocked cell. I think this is what your after -- y_not ------------------------------------------------------------------------ y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947 View this thread: http://www.excelforum.com/showthread...hreadid=523831 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to set the enter and arrow keys to skip locked cel
If that option is not available because you are using an earlier
version of xl you will have to... 1. right click the worksheet's Sheet Tab then select "View Code" in the popup that appears. 2. Go ViewProperties Window 3. In the lefthand column of the worksheet's Properties Window select "EnableSelection" 4. In the righthand column on the same line click on the down arrow then select "1 - xlUnLockedCells" 5. Press Alt + F11 to return to the worksheet. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't move from cell to cell with arrow or enter keys. Help! | Setting up and Configuration of Excel | |||
| Data Validation -- using arrow keys | Excel Discussion (Misc queries) | |||
| how do I move cursor without tab, enter or arrow in Excel | Excel Discussion (Misc queries) | |||
| when I protect my sheet enter tab, & arrow keys dont work... | Excel Discussion (Misc queries) | |||
| Enter, tab, arrow keys aren't allowing me to move to other cells | Excel Discussion (Misc queries) | |||
Linear Mode
