How to lock the 1st drop down list after a selections has been made.

[excelgreen]

Hello All,

Long time viewer but this is my first post. I have two drop down list that are interactive with each other on my form. The 2nd list is dependent on what is selected in the 1st list (indirect). So far they work great. The only issue I have is, excel will allow the user to change their selection in the 1st drop down list without making them change their selection in the 2nd drop down list. I need excel to zero or clear the 2nd list if a change is made to the 1st list. It looks like excel is recognizing this as a error too. When I make a change in the 1st list without changing the 2nd list and I click on "circle invalid data" it circles the 2nd list. Is there a way to lock this down via a formula or macro? Thanks in advance for your help and just let me know if you need anything else from me.


P.S. Does anyone know how to keep the little drop down arrow showing all the time? Even if you are not clicked on that cell?

 

[excelgreen]

I can post pictures or anything else that would help. Thanks.

 

[excelgreen]

Here is the answer if anyone else is looking for it.

http://www.excelforum.com/excel-worksheet-functions/773420-how-to-lock-the-1st-drop-down-list.html#post2513672