Hi Ron,

I'll give it a try. So basically the answer is MS removed the ability to
group selected objects using the mouse. It's either all or one at a time. I'm
not thrilled about having to introduce a macro into macro-free documents.
What if i only want to select them to move a bunch of them over a bit?

Squeaky.

"Ron de Bruin" wrote:

Hi Squeaky

See
http://www.rondebruin.nl/controlsobjectsworksheet.htm

You can use this code example to delete all shapes

Sub Shapes1()
'Delete all Objects except Comments
On Error Resume Next
ActiveSheet.DrawingObjects.Visible = True
ActiveSheet.DrawingObjects.Delete
On Error GoTo 0
End Sub

Or only checkboxes from Forms
ActiveSheet.CheckBoxes.Delete

Or ActiveX checkboxes

Sub OLEObjects3()
Dim obj As OLEObject
For Each obj In ActiveSheet.OLEObjects
If TypeOf obj.Object Is MSForms.CheckBox Then
obj.Delete
End If
Next
End Sub






--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"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