Hello all, i am trying to use a vba code to lock cells based on another cell value and facing difficulty. What i am trying to do is..
I have a dropdown in cell E4 with 4 selection e.g. A, B, C, D and i am trying to lock cell from E28 to E78 if i select A and G28 to G78 if i select B. when selecting C or D i need all cells to be unlocked.
I have unlocked E4 and protected entire sheet.
I would be very thankful for any assistance.
I have a dropdown in cell E4 with 4 selection e.g. A, B, C, D and i am trying to lock cell from E28 to E78 if i select A and G28 to G78 if i select B. when selecting C or D i need all cells to be unlocked.
I have unlocked E4 and protected entire sheet.
I would be very thankful for any assistance.