If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making Cells Non-Accessable
How do I make certain cells non-accessable? I would like to have the
worksheet so that only certain cells can be clicked and edited, but when you press enter, tab, or arrows the curser continues to the next "available" cell. |
#2
|
|||
|
|||
Making Cells Non-Accessable
You need to highlight the cells you want to access and then go to
FormatCells...Protection and un-check locked. Now go to ToolsProtectionProtect Sheet... and select any options you want here. Now pressing tab will cycle to the un-locked cells -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "robrockk" wrote in message ... How do I make certain cells non-accessable? I would like to have the worksheet so that only certain cells can be clicked and edited, but when you press enter, tab, or arrows the curser continues to the next "available" cell. |
Thread Tools | |
Display Modes | |
|
|