View Single Post
  #2   Report Post  
JethroUK©
 
Posts: n/a
Default

not practical - you will type mistakes (i was going to say 'might')

you would need a macro to lock cells as you type, and when you finished
choose:

ToolsProtectionProtect Sheet

to disable all locked cells

"Sureshsmartdc" wrote in message
...
I want lock a cell immediately when i entered a value. So that the user

cant
change the value what he entered. But it should be done automatically. The
very next process of his entry it should be done.