Grouping buttons in left-hand grid - can they be hidden?

[jday]

I have a worksheet that utilizes Excel subtotaling/grouping functionality
across the rows, however, I want to "hide" the grouping buttons (on the left
side of the Excel grid) if certain conditions are TRUE. Is there any way to
actually hide these buttons so the user cannot even see them? (vs. trying to
handle via protect/unprotect modes where the user can still see the buttons??)

 

[p45cal]

is
ActiveWindow.DisplayOutline = False
what you're after

 

[Dave Peterson]

You could hide all of them (or none of them).

In xl2003 menus:
tools|Options|view tab|uncheck (or check) Outline symbols

Record a macro if you want the syntax.

 

[jday]

That's exactly what I needed -- thanks so much!