Perhaps if you provide the code we can figure out what is happening.

Mike F
"broogle" wrote in message
oups.com...
I use drop down list in my data validation. The problem is, sometimes,
after I run the VBA code, the drop down list is missing. Any idea why
this could happen ? I have to exit from excel application and open it
again to get drop down list work as normal.
Thanks