| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
outline...hide levels
I AM TRYING TO HAVE A COMMAND BUTTON SHOW ALL LEVELS IN "TRUE" MODE AND HIDE
LEVELS IN "FALSE" MODE. I CAN SHOW THE LEVELS FINE, BUT CANNOT FIGURE OUT HOW TO HIDE THEM. HELP PLEASE! -- icebreaker914 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
outline...hide levels
iceBreaker..
turn on the macro recorder Tools/Options/View : uncheck Outline Symbols in window options. This is what you will get: ActiveWindow.DisplayOutline = False -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam icebreaker914 wrote : I AM TRYING TO HAVE A COMMAND BUTTON SHOW ALL LEVELS IN "TRUE" MODE AND HIDE LEVELS IN "FALSE" MODE. I CAN SHOW THE LEVELS FINE, BUT CANNOT FIGURE OUT HOW TO HIDE THEM. HELP PLEASE! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Intermediate Levels in Date Dimension | Excel Discussion (Misc queries) | |||
| Outline(grouping) more than 8 levels | Excel Discussion (Misc queries) | |||
| Hide Middle Levels | Excel Discussion (Misc queries) | |||
| Subtotal error to expand Outline Levels | Excel Discussion (Misc queries) | |||
| Outline and hide feature | Excel Programming | |||
Linear Mode
