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

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

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

is
ActiveWindow.DisplayOutline = False
what you're after?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=135016

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

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 wrote:

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

--

Dave Peterson

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

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

"p45cal" wrote:


is
ActiveWindow.DisplayOutline = False
what you're after?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=135016