Checkboxes and filters

[penny]

I have a filter in column A. Column B has my main descriptions. Column C has checkboxes inserted via the 'form' toolbar. Whenever I filter column A to show only 1's, the checkboxes in column C next to the rows with 0's stack over the other checkboxes. Is there a way to have checkboxes in column C that will go away for rows with '0' when it's filtered?

I've attached a screenshot of an example, as I'm not sure how to link it directly.

Thanks!

[Leith Ross]

Hello Penny,

Since the AutoFilter doesn't have any events that are exposed to VBA, there isn't a way to hide the CheckBoxes when the filter is selected.

Sincerely,
Leith Ross