Locking and Unlocking Cells Based On Value In Another Cell

virgostar02

New Member
Joined
Sep 19, 2014
Messages
1
Hello,

I am a VB newbie and I have been reading up on this feature, but I still can't seem to get it work for my specific case. I hate to bother anyone, but I finally had to buckle down and ask for help.

I am working in a protected worksheet. I would like to have cell H16 locked if the drop down value in cell H14 is "No". I would like cell H16 to be unlocked if the drop down value in cell H14 is yes AND the value in cell C7 is greater than or equal to 120.

Can someone please help?

Thank you in advance.

AJ
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,108,489
Messages
5,523,248
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top