I used a vlookup formula to control the content of E9 (MERGED AREA). If g12 (MERGED AREA) needs to be unlocked, the content of E9 will be "WF". All I need then is a code to unlock g12 if content of E9 is "WF". I would like it to clear g12 if the content of E9 is changed to something else other than "WF"
Here is the code that I tried but nothing seems to happen.
![]()
Please Login or Register to view this content.
Bookmarks