sh Singh
To: excel-macros@googlegroups.com
Sent: Mon, August 20, 2012 11:47:43 AM
Subject: Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells
Dear Paul,
First let me thanks you for prompt reply.
i have tried this ...
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Rang
@googlegroups.com
Subject: Re: $$Excel-Macros$$ help for Conditional Lock and unlock cells
Dear Paul,
First let me thanks you for prompt reply.
i have tried this ...
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If
Range("a4:a10").Value = "" Then Ra
Dear Paul,
First let me thanks you for prompt reply.
i have tried this ...
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If
Range("a4:a10").Value = "" Then Range("b4:B10").Locked = False Else
Range("b4:b10").Locked = True End If End Sub
But is not working
sheet can be prot
Hi Santosh,
Please send a sample file. and more explain. it's confusing.
Regards,
Kuldeep Singh
On Mon, Aug 20, 2012 at 8:37 PM, Santosh Kumar Singh wrote:
> Hay looking for help ..
>
> ** **
>
> *Column C*
>
> * D*
>
> open for entry
>
> a
>
> Locked
>
> d
>
> Locked*
Your request is somewhat confusing.
"locking" a cell does not necessarily mean "grayed out".
In order to lock a cell, two things have to happen.
1) the "locked" property of the cell must be set.
2) the sheet has to be protected (with or without a password)
For the cell to be "Grayed Out" means th
