![]() |
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?? |
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?? |
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?? |
All times are GMT +1. The time now is 05:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com