disable Subtotals Outline Symbols
 

I have a worksheet with Subtotals, that I do not want the
User to collapse. How can I (a) disable the Subtotal
Outline Symbols (+/- signs) when the opens the report or
(b) not display the outline symbols at all?

Thanks

disable Subtotals Outline Symbols
 

One way:

Cells.ClearOutline

You can do this via the GUI with Data/Group and Outline/Clear Outline


In article ,
"MC" wrote:

I have a worksheet with Subtotals, that I do not want the
User to collapse. How can I (a) disable the Subtotal
Outline Symbols (+/- signs) when the opens the report or
(b) not display the outline symbols at all?

Thanks