Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked cells in Excel 2000
Hi
In Excel 2003 when you protect a worksheet you can deselect "format locked cells" so that when you try to click on a locked cell in the spreadsheet you can't. Can you do this in 2000? Reason is I have set-up a tab order in my worksheet so that users can easily navigate to the data entry cells however if I accidently click out of the tab sequence into a locked cell it looses the tab order - I know I can reselect the 'named range' however a user won't? Thanks and Merry Christmas. Silena |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked cells in Excel 2000
The function is deselect "select locked cells" which was introduced in 2002.
But, in any version.................. If you are using the Tab key to move to unlocked cells you do not need a "named range" as long as your Tab sequence is left to right and top to bottom. If you mouse-click a locked cell then hit Tab key the sequence will jump to the next unlocked cell. Gord Dibben MS Excel MVP On Sun, 9 Dec 2007 13:59:02 -0800, Silena K-K wrote: Hi In Excel 2003 when you protect a worksheet you can deselect "format locked cells" so that when you try to click on a locked cell in the spreadsheet you can't. Can you do this in 2000? Reason is I have set-up a tab order in my worksheet so that users can easily navigate to the data entry cells however if I accidently click out of the tab sequence into a locked cell it looses the tab order - I know I can reselect the 'named range' however a user won't? Thanks and Merry Christmas. Silena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort locked cells in Excel? | Excel Worksheet Functions | |||
Excel locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
unlocked cells in excel 2000 now locked when opened in 2003 why? | Excel Discussion (Misc queries) | |||
All Cells in Excel are locked, what's wrong? | Excel Discussion (Misc queries) |