| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to display zero at the left hand of a code in a cell say 045 | Excel Discussion (Misc queries) | |||
| Grouping sheets with one hand in Excel | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side | Excel Discussion (Misc queries) | |||
| y-axis moves from the left hand side to the right hand side! | Charts and Charting in Excel | |||
| How do I get my y axis on the left hand side of my chart? | Charts and Charting in Excel | |||
Hybrid Mode
