HELP - DELETE ALL CHECKBOXES FROM A SHEET

Posted by Jiminey Dehey on January 15, 2002 7:40 PM

Hi.. I need a macro that will delete a whole lot of checkboxes from a worksheet all at once.

Thanks

Posted by Aron on January 15, 2002 11:57 PM

Try:

Sub deleteboxes()
For Each c In Sheets("Sheet1").CheckBoxes
c.Delete
Next
End Sub

Where: Sheet1 is the name of your sheet. Remember that this can't be undone if there are a lot of them - just in case you change your mind.

HTH,
Aron