Generally we need to have a global variable that will skip the dropdow
code using something like :-
Code
-------------------
Sub DropDown1_Change()
If DropDownDisable = True Then Exit Sub
' other code
End Sub
-------------------
--
Message posted from
http://www.ExcelForum.com