Hiding Rows with Checkboxes
 

Hi All --

I have multiple rows with checkboxes in column E & F of each row. If I
choose to hide some rows. The checkboxes from the hidden rows still appear,
though they do tend to overlap and consolidate into one row. This is true
whether I create Forms checkboxes or Control Tool checkboxes.

Is there anyway to use checkboxes but have them hide successfully when the
row(s) is hidden?

Thanks for your help.

Ellen

Hiding Rows with Checkboxes
 

try:
ActiveSheet.Shapes("CheckBox1").Visible = False


"Ellen G" skrev:

Hi All --

I have multiple rows with checkboxes in column E & F of each row. If I
choose to hide some rows. The checkboxes from the hidden rows still appear,
though they do tend to overlap and consolidate into one row. This is true
whether I create Forms checkboxes or Control Tool checkboxes.

Is there anyway to use checkboxes but have them hide successfully when the
row(s) is hidden?

Thanks for your help.

Ellen