I am trying to protect cells conditionally. I have data on row 5 A5-V5, some are formulas and already protected. I want to proctect all cells, A5-V5, as soon as someone types information in T5. This macro needs to progress down the sheet for each row, meaning that once T6 is populated all of row 6 is locked. Is this possible? Thank you in advance for any assistance.