MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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