I am building an table where I want specific cells in to be locked depending on value in another cell of the same row. This should apply to the entire table. To explain better, if in cell N3 "Custom" is selected from a drop down value, cells V3 to AA3 will be unlock. Any other value in N3 will keep the cells V3 to AA3 locked. This will need to repeat in all rows in my table, which may have upto 3000 rows. Any way to do this using VBA, I am very new to this so would need some step by step instructions. Thanks,