How do I get rid of a drop down box exported from a worksheet?
 

I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could
not delete a drop down box.

How do I get rid of a drop down box exported from a worksheet?
 

try
sub noshapes()
ActiveSheet.DrawingObjects.Delete
end sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"EW" wrote in message
...
I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could
not delete a drop down box.

How do I get rid of a drop down box exported from a worksheet?
 

Hi,

Did you try Ctrl + G Special Objects. This will select all objects
including drop down boxes. Now simply hit the delete button.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"EW" wrote in message
...
I exported data from another worksheet into excel from specific sortware.
Graphics came with the data. All the other ones I could delete but I could
not delete a drop down box.