Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i lock cell immediately if any value Entered?
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Here is an example of pseudo-protecting a cell. This macro looks for changes
to cell A1. The first time data is entered, the Macro "remembers" the value. If A1 changes after that, the macro will detect the change and restore A1 to the "remembered" value. You can adapt it to your needs. The Macro should go into the Worksheet code area. Dim sval As Variant Dim i As Integer Sub Worksheet_Change(ByVal Target As Excel.Range) If Intersect(Range("A1:A1"), Target) Is Nothing Then Exit Sub Application.EnableEvents = False If i = 0 Then i = 1 sval = Range("A1:A1").Value Else Range("a1:a1").Value = sval End If Application.EnableEvents = True End Sub -- Gary's Student "JethroUK©" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
Cell lock | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Syntax for inferred cell references | Excel Worksheet Functions | |||
lock a picture to a cell so i can mail merge | Excel Worksheet Functions |