deleting checkboxes

[marksuza]

Hi, I have worksheets with several checkboxes, but I dont want to select
them individually and press delete.

Is there a way to delete them all without having to do it one by one?

Thanks a lot.

Mark

 

[Andy Brown]

Hi, I have worksheets with several checkboxes ...

How many is "several"?

If you've no other objects on the sheet, you could F5 -- Special --
Objects -- OK, then delete en masse.

If you've other objects, you could select them sequentially using
CTRL+Shift.

If you've scores, post back -- Dave Peterson has written code for this, I'll
dig it out.

Rgds,
Andy


On the stereo this week ; Albinoni, Samuel Barber, Nirvana, Sinead O'Connor

 

[Andy Brown]

This suggestion from Ron de Bruin.

Rgds,
Andy


Sub test()
ActiveSheet.CheckBoxes.Delete
End Sub

 

[marksuza]

Thanks, that was really helpful.

Best Regards,

Marco