Locking cell dependence of the color.

[DeeWuu]

Hi all.
Fist post here and would need help from smarter then me, hence I register here.

I need lock automatically cell when color has changed. Color depends on the value from another cell, the value is taken from dropdown list.
I need the cell unlocked when is white and need locked when is oragneish, is this possible in VBA or just in conditional formatting?
There could be more cells then one with same color but they are in same row.

[hasan mougharbel]

please DeeWuu provide an excel file of what you need and you shall have direct assistance

[DeeWuu]

Apologies, I shall done this earlier.

[deadlyduck]

The attached edited version of your sample workbook will do what I understand you want to happen.

[DeeWuu]

Appreciate the answer, however it doesn't work as I would like.
Basically when I chose different item in D7 for example :
if in D7 I chose "fixture plate" then G7 is orange and lock as I like to be and F7 and I7 stays white and unlock which is perfect.
But when in D7 I change value to "MTS chuck" G7 is white and lock but I want unlock( because is white color) and F7 and I7 is orange and unlock which I want them to be locked due to orange color.
I hope my explanation is good enough for you to understand what I mean as its really difficult for me to put this on post.

Orange color- locked
white color - unlocked

[deadlyduck]

When I test it, the orange cells are locked and white cells are unlocked as you change D7.

Did you enable macros on the downloaded workbook? It's a macro-enabled workbook so you need to allow macros to run. You should see a yellow bar with 'Enable content' button displayed under the ribbon when you open the workbook- click that button.

You might also need to unblock the workbook - for instructions how to do this, see my signature under this post.

[DeeWuu]

WOW i fallowed your instruction and it's working on that workbook but i can't managed to put on workbook i really want as there are many codes already and they don't like each other...
So could you please look on new workbook I attached and please give me idea where to put them without breaking old codes as they I need them for something else.
Please look at the are wit thick black border. Thanks for your time

[deadlyduck]

In the Workbook_Open event procedure of the uploaded workbook, the code refers to a sheet called Archive which has some data and filters on it. However, that worksheet isn't included in the up;loaded workbook.

If you want someone to examine the code and find debugging errors, you'd need to upload as full a workbook as possible, removing confidential details (make up names of people etc).
Otherwise, it's too messy trying to compensate for omissions that trigger errors when opening and using the workbook.

[DeeWuu]

hopefully now be OK. My file its to big to upload, will try to shirk it and then.

[deadlyduck]

There is no workbook available to download now?

[DeeWuu]

Unfortunatelly im no able to shirk workbook unless I delete archive sheet and two different ones....
If you can'T do it its fine I understand, no worries, you helped me any way

[deadlyduck]

Could you give precise sheets and cell addresses that you want to have the desired code attached to- I can't find them

EDIT- I think it's change cell F17 and enable/disable cells G17, I17 and J17.

The way the attached is setup is if a cell (G17/I17/J17) is orange, it's locked. If it's white, it's unlocked. Your conditional formatting sets the cell's colour so once the conditional formatting is correct, those cells will be locked/unlocked whenever you change cell F17.

If this solves your issue, mark the thread as SOLVED at the top of your first post.

[DeeWuu]

Ok, so if :
IN cell E17 is "N" the cell in thick black boarders become orange and needs to be locked but unlocked when they are white, they become white when in E17 is Y
Basically cells in black thick border need to be locked when orange and unblocked when white, when the value change in E17 and/or F17

[deadlyduck]

I think this is now working

[DeeWuu]

Almost there, its closer then further from solving this, thanks a lot for your time and help.

[deadlyduck]

I added a check for protection of sheet4- that might have been an issue when first opening and trying to change cell E17 or F17.

[DeeWuu]

It all working now how I wanted! Thank you so much for you time and help! You are legend.