disable Subtotals Outline Symbols

M

MC

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
 
J

J.E. McGimpsey

One way:

Cells.ClearOutline

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

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

Similar Threads

Printing Outline view - formatting lost 0
Delete all data after a symbol in a field 0
FIND ALL 1
Combine Sumifs with Subtotal 0
Showing Outline Symbols 0
Display Outline Symbols 0
Subtotals by Column 1
FIND ALL 0

Top