In Excel 2003, I couldn't reproduce the problem with a Data Validation
dropdown whether it was visible or not at the time the command was issued.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...

...
Just to add -
You only need to be this elaborate if you have Autofilter dropdowns on
your
worksheet -

or Data Validation.

And if you do, and you delete them, you can't get them back.