Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotals without left outlines
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No plus or minus signs to left of subtotals | Excel Worksheet Functions | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Excel subtotals do not show on left of row numbers | Excel Worksheet Functions | |||
Insert-Subtotals makes Column Outlines disappear | Excel Worksheet Functions | |||
SubTotals or Outlines to the left? / on Top ? | Excel Programming |