E
ExcelMan
I am creating subtotals (via VBA) in a sheet that already has outlining
on certain sets of columns. My code also hides some of the rows, so
when I am using the subtotal function I use parameter 109 (instead of
9) so that hidden rows are skipped when calculating the subtotals.
Problem is, when the user collapses one of the groups created by the
subtotaling, the sums go to zero because all the rows are hidden.
I would like to disable the little plus/minus buttons on the left side
of the sheet so the user cannot collapse individual groups. I would
like the 1, 2, 3 buttons on the top left column of the screen to remain
in place so the user can collapse ALL of a level if they desire. I
just don't want them collapsing a single group.
Is there any way to do this. REMEMBER: I have outlining on the columns
so I cannot just completely do away with all grouping/outlining. I
need to retain the existing outlining on the columns.
Thanks
on certain sets of columns. My code also hides some of the rows, so
when I am using the subtotal function I use parameter 109 (instead of
9) so that hidden rows are skipped when calculating the subtotals.
Problem is, when the user collapses one of the groups created by the
subtotaling, the sums go to zero because all the rows are hidden.
I would like to disable the little plus/minus buttons on the left side
of the sheet so the user cannot collapse individual groups. I would
like the 1, 2, 3 buttons on the top left column of the screen to remain
in place so the user can collapse ALL of a level if they desire. I
just don't want them collapsing a single group.
Is there any way to do this. REMEMBER: I have outlining on the columns
so I cannot just completely do away with all grouping/outlining. I
need to retain the existing outlining on the columns.
Thanks