Using VB to Lock Cells based on value in another cell

Feb 27th, 2002, 07:59 AM

Is there a way to lock cells using VB based on the value of another cell. Example:

IF A2 = A1 then
Locked Cells C2 and D2 from data entry.

Thanks.

Juan Pablo González · Feb 27th, 2002, 08:02 AM

Put this macro in the sheet's module.

Private Sub Worksheet_Calculate()
If [A2] = [A1] Then [C2:D2].Locked = True Else [C2:D2].Locked = False
End Sub

Feb 27th, 2002, 08:02 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Put this macro in the sheet's module. Private Sub Worksheet_Calculate() If [A2] = [A1] Then [C2:D2].Locked = True Else [C2:D2].Locked = False End Sub __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 07:59 AM	#1
Guest Posts: n/a	Is there a way to lock cells using VB based on the value of another cell. Example: IF A2 = A1 then Locked Cells C2 and D2 from data entry. Thanks.