its doing the same thing i guess can you check it
On Wed, May 18, 2011 at 4:06 AM, Vinod Narayanan nvino...@gmail.com 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 /
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)
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
Hi Team,
Request you to help me creating an assessment sheet wherein the person
taking the test, once chooses the option given in column C, the particular
cell should freeze...
If the question is given B3 cell and the corresponding answers in C3 (either
drop down or need to key in ... depending
