disable Subtotals Outline Symbols

  • Thread starter Thread starter MC
  • Start date Start date
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
 
One way:

Cells.ClearOutline

You can do this via the GUI with Data/Group and Outline/Clear Outline
 
You must log in or register to reply here.

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

FIND ALL 1
Calculating subtotals 22
Subtotals by Column 1
outline symbols (1,2,3) don't show up when subtotal a list 1
subtotals 1
Paste Special Values 2
cannot expand outline on protected sheet 2
Subtotal Formatting 2

Back
Top