I have never worked with VBA. What i am wanting to do is I have a data validation list in C20 and depending on what they person chooses from the list I want to have F20 locked or unlocked. The list is 300, 400, 600, 800, 1200, and "Other". If they select one of the numbers in the list it will lock F20 but if they select "Other" it unlocks F20 so they can manually type a number. Also it would need to run automatically when the workbook is opened.