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

Hello, can I throw a related question in to this thread? I've been wading
thru hundreds of articles on Excel book/sheet password protection, cell
locking, sharing, read/write access, etc. etc. and have not found anything to
protect against someone completely over-writing an entire file, .....as long
as they have access to the shared folder itself. Even if they don't have any
of the read or write passwords, they can still do a "save as" and over-write
the entire file. Granted, they must reply YES to the prompt, "Do you want to
replace this file" but that's not much of a deterrent. Have you run in to
this or have any ideas?

"Norm" wrote:

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

Morning Debbi-PCH,

I'm not an expert in excel but you might want to try and Google "How to
protect...." or you can try these sights:

http://www.dotxls.com/excel-security...eet-protection

http://www.xcelfiles.com/

http://spreadsheets.about.com/

Hope this helps.

Norm



"Debbi-PCH" wrote:

Hello, can I throw a related question in to this thread? I've been wading
thru hundreds of articles on Excel book/sheet password protection, cell
locking, sharing, read/write access, etc. etc. and have not found anything to
protect against someone completely over-writing an entire file, .....as long
as they have access to the shared folder itself. Even if they don't have any
of the read or write passwords, they can still do a "save as" and over-write
the entire file. Granted, they must reply YES to the prompt, "Do you want to
replace this file" but that's not much of a deterrent. Have you run in to
this or have any ideas?

"Norm" wrote:

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