delete a check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Check Boxes 3
delete caption on multiple check boxes 2
How do I delete an already created series of check boxes? 2
Check Boxes 1
How to remove a picture box from an Excel 2007 spreadsheet. 2
Deleting Rows - only deletes content 2
Check Box wont Delete 3
Duplicates Deletion ? 2

Back
Top