i not remember way you say delete boxs in old excels but this makro delets
check boxes in range you select first

Sub DelCkBoxes()
Dim Ck As CheckBox
For Each Ck In ActiveSheet.CheckBoxes
If Not Intersect(Ck.TopLeftCell, Selection) Is Nothing Then
Ck.Delete
End If
Next
End Sub


"Squeaky" wrote in message
...
|I have a spreadsheet with about 600 check boxes where I need to delete
about
| half of them.
|
| In previous versions I could select as many objects as I chose by simply
| drawing a box around them to select them and hitting delete.
|
| It seems in 2007 I can either choose them all at once or one at a time,
| nothing inbetween. Is this nightmare scenario correct or is there a way?
|
| Squeaky