I have checkboxes on a worksheet from the Forms tool bar. The checkboxes are
in a named range on the sheet.

I want to loop through these checkboxes (the ones in the named range only)
and delete the ones that are checked along with the row that it sits on. I
would also like to do the reverse i.e. delete all of the ones that are not
checked.


I have made a ShapeRange and can loop through them but I can't figure out
how to manipulate them.


Thanks

using excel 2003