| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| How do I delete checkboxes from rows I deleted in a macro? | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Linear Mode
