Auto locking cells

**:) Sixthsense :)** · 04-30-2013, 01:00 AM

You can't use sheet protection when the file is in shared mode

**mifzal.mufthi** · 04-30-2013, 03:27 AM

Originally Posted by :) Sixthsense :)

You can't use sheet protection when the file is in shared mode

Thanks but I don't think you have understood the question. I know that protection cannot be enabled while on sharing mode. I know how to enable protection too. What my question is, how do I protect cells as soon as I enter a data? The purpose of doing that is to prevent deleting or modifying data. Once a data is entered, it should automatically lock the cell. How do I do that?

**:) Sixthsense :)** · 04-30-2013, 03:29 AM

Again, protecting the cell content can't be done without using the sheet protection

**mifzal.mufthi** · 04-30-2013, 03:33 AM

Originally Posted by :) Sixthsense :)

Again, protecting the cell content can't be done without using the sheet protection

READ MY ENGLISH. I know how to protect worksheet. I am expecting a solution to my question

**Fotis1991** · 04-30-2013, 03:54 AM

Originally Posted by mifzal.mufthi

READ MY ENGLISH. I know how to protect worksheet. I am expecting a solution to my question

IS THIS IN ENGLISH??? And as you expect a solution to your question and we MUST(we had to.) give a solution...

http://chandoo.org/forums/topic/lock...-entry-in-cell

**mifzal.mufthi** · 04-30-2013, 04:18 AM

Originally Posted by Fotis1991

IS THIS IN ENGLISH??? And as you expect a solution to your question and we MUST(we had to.) give a solution...

http://chandoo.org/forums/topic/lock...-entry-in-cell

I know 0 about coding. So, can you please explain me the step by step process?

**Fotis1991** · 04-30-2013, 04:37 AM

Originally Posted by mifzal.mufthi

READ MY ENGLISH. I know how to protect worksheet. I am expecting a solution to my question

if you formulate your request, more politely, be sure that you'll find your solution..

**mifzal.mufthi** · 04-30-2013, 05:20 AM

Originally Posted by Fotis1991

if you formulate your request, more politely, be sure that you'll find your solution..

Yes I understand. I've asked the question politely and the person replied didn't seem to have understood the question. I kept repeating. You'll understand if you read the thread. Anyways, will you be able to find a solution for me please?