Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Hide checkboxes when hiding rows

Tags:

excel

hide

rows

I have used VBA code to hide some rows. These rows are hidden when I click a check box.

The problem I have now is - the check boxes associated with each row will not hide. This also interferes with my original VBA code to hide the rows and stops working. I would like to hide these check boxes with the rows.

SO18137495 question example

Please can you advise?

like image 607
user2533460 Avatar asked Aug 08 '13 22:08

user2533460


1 Answers

You need to set the checkboxes to "Move and Size With Cells." The last time I did this, with Excel 2003 it was easy: just right-click, choose "Properties" and choose that option. Now if you try that you'll see the option, but it's disabled:

enter image description here

So instead you need to access the more modern-looking format menu in Excel 2007 onwards. I did it by clicking the little "more" arrow on the Drawing Tools tab's Format group. For some reason it's enabled there. Once you set it your checkbox will hide with its row:

enter image description here

like image 107
Doug Glancy Avatar answered Sep 20 '22 19:09

Doug Glancy