Hide checkbox along with row

[a_greyish_iron]

My excel sheet has multiple rows of data and each row has a checkbox in it.
Now, on some condition, I want to hide certain rows along with their checboxes. On hiding the rows, expectedly, the checkboxes are not getting hidden along with it.

I have seen a few sample VBA codes which solve the problem but all of them use the "For each checbox in ActiveSheet.Checkboxes" construct and then hide the checkboxes that fulfill a certain condition through the Visible property.

I dont want to use the FOR construct as my sheet has more than 500 checkboxes and on hiding/unhiding the rows frequently, the excel is getting slow as it has to loop through all the checkboxes in the sheet.

Does anybody have any other ideas on how can I do this?

 

[Gary McMaster]

One way might be to append the row number or cell address to each check box name. Then as you hide the rows you could build a check box name from the row number and address each check box by name.

Gary