Conditional cell lock

**coolanks** · 05-29-2008, 03:19 AM

Hi Friends, am in some serious problem and hope somebody would get me out from trouble here.I have an sheet(see attached) with some dummy data, now i want to lock (with password) only those cells depending on the dropdown (highlighted in sheet).For eg,if we select A from dropdown of col c and then locked from dropdown of col D , it should lock the complete row(s) of value A in col H and rows with value B shall remain editable.Am counting on you guys to put me on track and your help would be immensely appreciated.

Thanks
Ankur

**coolanks** · 05-29-2008, 04:29 AM

Hi , I typed in the following code for this problem.But still am not able to get the desired results.Any help from anybody??

Please Login or Register  to view this content.

**royUK** · 05-29-2008, 05:42 AM

You can't use Target like that, Target refers to the cell(s) selected.

Try this amended code

Please Login or Register  to view this content.

**coolanks** · 05-29-2008, 06:11 AM

Hi roy, thanks for ur help, but am still facing issues with the sheet.If i put value A and B alternatively in col H ,the code doesn't work anymore.Hope i have made myself clear to you.Let me know should you require more information from my side.

Ankur

**royUK** · 05-29-2008, 07:41 AM

The code I gave you checks each cell in Column H of the table of data to see if it matches C2, if it does it will lock or unlock the cells based on the selection in D2

**coolanks** · 05-29-2008, 08:49 AM

Roy, Can i have urs workbook?? In my workbook its not working.....Thanks for your help

Ankur

**coolanks** · 05-29-2008, 08:53 AM

Roy,

Have attached the workbook with the mentioned code.pls help

**royUK** · 05-29-2008, 09:09 AM

I can't download the workbook, try zipping it.

**coolanks** · 05-30-2008, 12:38 AM

I have winrar,will it work?

Ankur

**royUK** · 05-30-2008, 01:22 AM

zip it with any program, even Windows XP

**coolanks** · 05-30-2008, 01:32 AM

Roy, Done the same as advised.Pls find the zipped file attached.

**royUK** · 05-30-2008, 05:01 AM

I've changed the code slightly

**coolanks** · 05-30-2008, 06:04 AM

Roy,

You are amazing, the sheet looks what i wanted to be.Just one more help (sorry but may be am getting greedy:-))instead of selecting locked/unlocked from dropdown can we lock cells with the help of system time? To elaborate it further , i want rows marked A in col H to be locked between say 02:00 am till 10:00 am (only rows marked B in col H should be editable during that time) and rest of the time i.e from 10:01 am till 01:59am rows marked B in col H should be locked and rows marked A in col H should be editable now.I know am compounding your problems further but i would really appreciate if you can do it for me.let me know if you need more clarification/information.

Thanks//Ankur

**royUK** · 05-30-2008, 07:27 AM

Originally Posted by coolanks

Roy,

You are amazing, the sheet looks what i wanted to be.Just one more help (sorry but may be am getting greedy:-))instead of selecting locked/unlocked from dropdown can we lock cells with the help of system time? To elaborate it further , i want rows marked A in col H to be locked between say 02:00 am till 10:00 am (only rows marked B in col H should be editable during that time) and rest of the time i.e from 10:01 am till 01:59am rows marked B in col H should be locked and rows marked A in col H should be editable now.I know am compounding your problems further but i would really appreciate if you can do it for me.let me know if you need more clarification/information.

Thanks//Ankur

You have already asked this question

**coolanks** · 05-30-2008, 08:16 AM

I Did Roy, but am still to get any favourable response.Hope you would understand.

Regards//Anks

**royUK** · 05-30-2008, 09:57 AM

Try this, you might want to put it in the WorkBook_Open event or maybe sheet_activate.

Please Login or Register  to view this content.

Conditional cell lock

LinkBack

Thread Tools

Rate This Thread

Display

Conditional cell lock

conditional lock

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions