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

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??)
 
D

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.
 

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

Top