| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Outline Symbols | Setting up and Configuration of Excel | |||
| Showing Outline Symbols | Excel Discussion (Misc queries) | |||
| How do I print outline symbols in Excel? | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Cannot see outline symbols | Excel Discussion (Misc queries) | |||
![MC[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
