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 Sub


It 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: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533140

to 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.
--
Basilio


"mrice" wrote:


Try this macro

Sub Test()
For Each Shape In ActiveSheet.Shapes
Shape.Delete
Next
End Sub


It 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: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533140