Unlocking Cells Based Upon Value of Another Cell
I have two columns (J and K - rows 4 through 133) on a sheet called "SMATV". In J a user will input a channel number and in column K it will state a channel name via a vlookup on another sheet. All this is done but here's the issue......channels 2-99 don't have a name to lookup. It will be a user inputted name. I wanted to lock down column J since it's a formula but I need the user to be able to input a name if the value in column J is less than 99. Is there a way using vba to unlock the cell and clear the formula so the user can input a name if J is less than 99?