I need the checkbox to be deleted when the row is deleted...

[ValiMandy]

Hello,

I have a spreadsheet where there are checkboxes for each row. I have a macro that deletes unwanted rows, but the checkboxes remain. How do I get them to be deleted when the row is deleted?

Please save me!

Mandy

 

[baitmaster]

are they "form" checkboxes or ActiveX checkboxes?

And how many are there, are they consistently named, do they lie within the row boundaries etc. Oh and what version Excel are you using?

 

[ValiMandy]

are they "form" checkboxes or ActiveX checkboxes?

And how many are there, are they consistently named, do they lie within the row boundaries etc. Oh and what version Excel are you using?

Hi! Thanks for helping.

They are form checkboxes. There are 42. They are all named "Mixed Pallet". They each lie within in a single cell. Rows 4-45. Version: Excel 2016

Thanks again!