View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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