software

I created a check box using the forms toolbar for a cell in Excel 2000. I
want to delete the check box but when I right click it and select cut it
won't go away. It's like there are hundreds or maybe thousands of them
layered on top of each other. I've tried deleting the row, deleting the
column, clearing the contents of the cell, but nothing works.


Try this macro

Sub Test()
For Each Shape In ActiveSheet.Shapes
Shape.Delete
Next
End SubIt would be worth checking that you have not got objects protected on
the sheet.

You could also try

F5 - Special - Objects - delete key.

Martin

Martin--
mrice------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533140to delete the check box you have to enter the desigh mode for that tool.Open
your toolbox and check the design icon.then you mark it and delete it.
--
Basilioquot;mricequot; wrote:

gt;
gt; Try this macro
gt;
gt; Sub Test()
gt; For Each Shape In ActiveSheet.Shapes
gt; Shape.Delete
gt; Next
gt; End Sub
gt;
gt;
gt; It would be worth checking that you have not got objects protected on
gt; the sheet.
gt;
gt; You could also try
gt;
gt; F5 - Special - Objects - delete key.
gt;
gt; Martin
gt;
gt; Martin
gt;
gt;
gt; --
gt; mrice
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
gt; View this thread: www.excelforum.com/showthread...hreadid=533140
gt;
gt;