Create a new worksheet
Add two cells with Data|validation (with a list)

Then step through this code:

Option Explicit
Sub testme()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
shp.Delete
Next shp
End Sub

You'll break the data validation dropdown for those cells.

Ron has some notes:
http://www.rondebruin.nl/controlsobjectsworksheet.htm
Look for: Only delete the controls from the Forms toolbar

That show you ways to be more careful.



Brisbane Rob wrote:

Thanks.

What's this about deleting shapes with codes (which I did do on the
sheet)?

--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=493915

--

Dave Peterson