How to select and delete all check boxes on a sheet?

[mindlessmalk]

I have inserted hundreds of check boxes into a form and now i need to remove a good portion of them. so far the only way i have found ot do this is to hold CTRL and click each one to select them and then press delete.

Is there a window select tool for form objects? Is there a way i can select all form objects on a sheet and delete them? It would be easier to reinsert the few boxes that need to stay than it will be to manually select and delete them all.
Thanks!
Nate

 

[jim may]

What method did you use to to set up the checkboxes?

 

[mindlessmalk]

I placed a single check box control into one cell, then copied and pasted the cell into many other cells.

 

[Datsmart]

See Erik's VBA code here:
http://www.mrexcel.com/forum/showthread.php?p=1166001

You can set the range and the type of object to delete.

 

[mindlessmalk]

That worked perfectly! Thanks!