Microsoft Excel - Grouping In Excel

I am curious if there is way to make my checkboxes invisible when I've grouped a number of cells with multiple (or even one set) checkboxes in that group.

So what I have is a group (i.e; rows 5-50) that have multiple Yes/No checkboxes in them and I want to group these cells which I have already done.  However, once I click on the minus sign to have them grouped, All of the checkboxes are still showing (all stacked on top of one another) on the grouping Header.

I believe myself to be lessened in excel with formulas and macros but I'm not very good at writing VBA codes so please be gentle with me...

Thanks

Daniel R

Hi Daniel,

It sounds like you are using checkboxes from the Forms toolbar in your cells, and then creating an Outline or Subtotals with those cells.  I think the problem is: those checkboxes are Objects, and Excel will not hide them when the cells are hidden (that's why you see them all stacked together).

To solve this the way you are doing it, I think it would take some moderately complex VBA code.  Instead of using checkboxes, you may want to consider using data validation in those cells, if possible.  That way, your users can still click in the cell to change the value, and you won't have the checkbox issue.

If you upload your file, I can take a look and suggest a solution...