Locking cell with Macro

[prajul89]

I have done this a lot of time before with Range.Locked = True statement, and it worked too.
But somehow the statement is not working for some cells.
I even checked the cell property where the lock check box was ticked. So my macro statement did the job. But still the user can change the cell value. There is something that I am missing. Please Help

 

[prajul89]

I really don't know what was wrong with that file. I made a new workbook trasfered all macro to this new workbook without any change and it worked. God knows what happened.

 

[ravi4ever]

Its always a good idea to try to a new workbook or on a new system. Good that now its working for you.