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

  • Thread starter Thread starter jday
  • Start date Start date
J

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??)
 
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.
 
Back
Top