its doing the same thing i guess can you check it
On Wed, May 18, 2011 at 4:06 AM, Vinod Narayanan wrote:
> Hi Ashish,
>
>
> Thanks for your help... As i have explained in my previous mail, its a
> questionnaire and the cell should freeze the moment the answers is chosen /
> writtten
>
> Th
Hi Ashish,
Thanks for your help... As i have explained in my previous mail, its a
questionnaire and the cell should freeze the moment the answers is chosen /
writtten
The macro freezes the moment an answer for a single question is answered...
but what i require is
when a person answers a qu
http://akoul.blogspot.com/search?q=protect
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
'target.column =3 because column c is no 3 column
'you can change password ashish and choose your own
ActiveSheet.Unprotect Password:="ashish"
If Not IsEmpty(Target.Value
