MikeTVC wrote...
....
What I am trying to do is provide the capability that as the status for a
month is changed to "Closed", all the cells in that month column within
each of the rows would be automatically locked so the data could no longer
be altered. . . .
....
. . . I'm sure it can be done with a macro of some sorts, but
that seems overly complicated. . . .
....

Overly complicated or not, this can ONLY be done by a macro or
manually. If you don't want to do this manually, your only alternative
is using macros.