Re: $$Excel-Macros$$ Freeze/Unalterable Cells
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 / writtten The macro freezes the moment an answer for a single question is answered... but what i require is when a person answers a question(b3) the answer in C3 should only freeze... then when he answers a question (B4), the answer in C4 should only freeze.. so on.. Please help me On Tue, May 17, 2011 at 10:00 PM, ashish koul koul.ash...@gmail.comwrote: 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) Then Target.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan nvino...@gmail.comwrote: 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 upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Freeze/Unalterable Cells
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) Then Target.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan nvino...@gmail.com wrote: 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 upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Freeze Cells.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Freeze/Unalterable Cells
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 question(b3) the answer in C3 should only freeze... then when he answers a question (B4), the answer in C4 should only freeze.. so on.. Please help me On Tue, May 17, 2011 at 10:00 PM, ashish koul koul.ash...@gmail.com wrote: 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) Then Target.Locked = True End If ActiveSheet.Protect Password:=ashish Else: End If End Sub On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan nvino...@gmail.comwrote: 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 upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Freeze/Unalterable Cells
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 upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Freeze Cells.xls Description: MS-Excel spreadsheet