I want to unlock cell g12 (whole sheet is protected only unlocked cells can be selected) if cell h7 (a merged range of cells) is either Grass Fire or Timber Fire. H7 is a list validated cell so there will be several other options but I only want it to unlock g12 if it is one or the other. What I will be doing later is requiring g12 to be filled in if unlocked before my save macro is able to be run.

I was given this code but it seems as if it does nothing different for me.


Please Login or Register  to view this content.
Thanks in advance!