Subtotals without left outlines

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top