See Tom's reply
Much better for you
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Ron de Bruin" wrote in message ...
For all Shapes on your worksheet you can use this
ActiveSheet.DrawingObjects.Delete
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Chip" wrote in message oups.com...
I want to be able to delete (using VBA) all the dropdowns on a
worksheet. When I record the act of deleting a dropdown I get:
ActiveSheet.Shapes("Drop Down 24").Select
Selection.Delete
How to I do it for more than Drop Down 24?