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
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