Select all checkboxes in worksheet/workbook

[klarowe]

How can I select all the checkboxes in either a sheet or a workbook and change them all to "move but do not resize with cells"??? Its a major PITA trying to go through them one at a time or even holding ctrl to select multiple... esspecially when there are over a couple hundred on my reports

 

[MickG]

Perhaps:-
"Forms control"

Private Sub CommandButton1_Click()
  ActiveSheet.CheckBoxes.Placement = xlMove
End Sub

"ActiveX controls"

Private Sub CommandButton2_Click()
Dim shp As OLEObject
For Each shp In ActiveSheet.OLEObjects
    If TypeName(shp.Object) = "CheckBox" Then
        shp.Placement = xlMove
    End If
Next shp
End Sub

 

[klarowe]

Had a feeling it was simple. Thanks