Learn Excel Episode 593: Unprotect Green Cells
Today, the questioner asks how to unprotect the green cells. There isn’t any good way to do this in the Excel user interface, so in Episode 593, I use a tiny bit of VBA code to achieve the effect.
The code used in the podcast is:
For each Cell in Selection
If Cell.Interior.ColorIndex = 4
then Cell.Locked = False
Else Cell.Locked = True