| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting Worksheet - Cannot move between cells.
I have locked & unlocked the necessary cells, and have protected my worksheet
(Tools/Protection/Protect Sheet). I cannot move up, down, left or right between cells. But if the sheet is unprotected I can easily do this. No, it's not the scroll button, I tried. Does anyone know how to fix this?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Worksheet - Cannot move between cells.
Could be your worksheet protection options.
When you protect your worksheet, do you allow the option to select locked and unlocked cells? -- Steve "GEM" wrote in message ... I have locked & unlocked the necessary cells, and have protected my worksheet (Tools/Protection/Protect Sheet). I cannot move up, down, left or right between cells. But if the sheet is unprotected I can easily do this. No, it's not the scroll button, I tried. Does anyone know how to fix this?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting Worksheet - Cannot move between cells.
Yes, I select the option to select unlocked cells...
"AltaEgo" wrote: Could be your worksheet protection options. When you protect your worksheet, do you allow the option to select locked and unlocked cells? -- Steve "GEM" wrote in message ... I have locked & unlocked the necessary cells, and have protected my worksheet (Tools/Protection/Protect Sheet). I cannot move up, down, left or right between cells. But if the sheet is unprotected I can easily do this. No, it's not the scroll button, I tried. Does anyone know how to fix this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting selected cells in a worksheet | Excel Discussion (Misc queries) | |||
| Protect selected cells without protecting worksheet | Excel Discussion (Misc queries) | |||
| WHEN I GROUP IT ERRORS WITH 'CANNOT MOVE CELLS OFF WORKSHEET?? | Excel Worksheet Functions | |||
| How To Lock Cells and Columns without Protecting Worksheet | Excel Worksheet Functions | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Linear Mode
