Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks

I work with cell locked/unlocked and sheet protection a lot.
I'm willing to help you, but I quite don't understand the question at hand
here.


"Norm" wrote:

Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks

To start with : all cells are locked by default, so if you protect the
worksheet then you will not be able to write in them ( cells ). Now if you
unlock some cells, then you have the choice to allow users to use "the unlock
ones or all.
"FC" wrote:

I work with cell locked/unlocked and sheet protection a lot.
I'm willing to help you, but I quite don't understand the question at hand
here.


"Norm" wrote:

Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks

Hey FC,

Here is what is happening, hypothetical, two columns (A,B) and 12 rows,
column A is my primary,column B changes, at the very last two rows (B11,B12)
locks and the prior rows are unlocked why does this happen and is their a
resoultion.

Thanks again

"FC" wrote:


To start with : all cells are locked by default, so if you protect the
worksheet then you will not be able to write in them ( cells ). Now if you
unlock some cells, then you have the choice to allow users to use "the unlock
ones or all.
"FC" wrote:

I work with cell locked/unlocked and sheet protection a lot.
I'm willing to help you, but I quite don't understand the question at hand
here.


"Norm" wrote:

Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks

Do this : click on the "all" button (left top space between 1 and A) to
select the whole sheet. Go to format-cells-secutity and then check locked,
click ok.
All the cells are locked now. Select the one you want to use ej : B1 to B12
and go to format-cells-security UNCHECK lock and click ok.
Then protect the worksheet and allow users to use unlock cells.
Result : nobody , unless with the password can write in the worksheet except
in cells B1 to B12 (unprotected)

"Norm" wrote:

Hey FC,

Here is what is happening, hypothetical, two columns (A,B) and 12 rows,
column A is my primary,column B changes, at the very last two rows (B11,B12)
locks and the prior rows are unlocked why does this happen and is their a
resoultion.

Thanks again

"FC" wrote:


To start with : all cells are locked by default, so if you protect the
worksheet then you will not be able to write in them ( cells ). Now if you
unlock some cells, then you have the choice to allow users to use "the unlock
ones or all.
"FC" wrote:

I work with cell locked/unlocked and sheet protection a lot.
I'm willing to help you, but I quite don't understand the question at hand
here.


"Norm" wrote:

Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks

Hey FC,

Thanks a lot, I actually tried that method before and totally forgot to use
this format a second time around, it works.
So, again, I thank you

"FC" wrote:

Do this : click on the "all" button (left top space between 1 and A) to
select the whole sheet. Go to format-cells-secutity and then check locked,
click ok.
All the cells are locked now. Select the one you want to use ej : B1 to B12
and go to format-cells-security UNCHECK lock and click ok.
Then protect the worksheet and allow users to use unlock cells.
Result : nobody , unless with the password can write in the worksheet except
in cells B1 to B12 (unprotected)

"Norm" wrote:

Hey FC,

Here is what is happening, hypothetical, two columns (A,B) and 12 rows,
column A is my primary,column B changes, at the very last two rows (B11,B12)
locks and the prior rows are unlocked why does this happen and is their a
resoultion.

Thanks again

"FC" wrote:


To start with : all cells are locked by default, so if you protect the
worksheet then you will not be able to write in them ( cells ). Now if you
unlock some cells, then you have the choice to allow users to use "the unlock
ones or all.
"FC" wrote:

I work with cell locked/unlocked and sheet protection a lot.
I'm willing to help you, but I quite don't understand the question at hand
here.


"Norm" wrote:

Hola,

I've done the:
Format....cells....protection...and uncheck the 'locked' box.
Then protected the whole worksheet, which only allow users to enter data in
the cells I have formatted as not locked.
My question at hand is why are the cells locking in the unlocked portion not
designated to be locked, is this supposed to happen or is their something
wrong with my pc or software, any help would be greatly appreciated.

Thanks