ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting Worksheet - Cannot move between cells. (https://www.excelbanter.com/excel-discussion-misc-queries/238257-protecting-worksheet-cannot-move-between-cells.html)

GEM

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??

AltaEgo

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??



GEM

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