Hi!
Can somebody help me with a VBA code that can lock cells in some ranges (e.g. E2:E5000,F2:F5000,G3:G5000,L3:L5000,N3:N5000,AA3:AA5000,etc), based on a text value in range B2:B5000 (e.g. "Activity" - selected from a dropbox list). I use Office 2013, and the worksheet is protected with a password (don't know if it matters).
Thank you so much in advance!
Copy this code, right-click the sheet tab, select "View Code", and paste the code into the window that appears. You should make sure that column B (at least) is unlocked, and that the "Password" is changed to the actual password - I had to assume that you only wanted the cells on the same row as the value in B to by locked....
Please Login or Register to view this content.
Your assumption is correct. That's exactly what I need.
Testing the code a bit more I noticed that if I change the text value in row B, after I previously selected "Activity", the code doesn't unlock the cells in columns E:G,L:L,N:N,AA:AA. This is quite a problem, because if the user selects by mistake "Activity" and afterwards selects the right text value, he cannot fill in the cells in columns E:G,L:L,N:N,AA:AA anymore.
Can this flaw be fixed?
Last edited by boboivan; 02-12-2014 at 03:19 AM.
Of course
Please Login or Register to view this content.
Thank you sir!
You know what's curious? I've tried today to add in the code exactly the same line as you did.
Didn't work for me. I have no idea why.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks