Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group & Outline - how do I hide detail programmatically
Dear all,
I've written some code that runs down a column and uses the data therein to group some rows together. All so far so good, but I want the default display to be with detail hidden. Any pointers? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group & Outline - how do I hide detail programmatically
I'm going to answer my own question in case anyone else searches and finds
it... I used ExecuteExcel4Macro "SHOW.DETAIL(a,b,c,d)" In the string a,b,c,d the letters represent the following: a=1 (indicates rows) b=last row number to hide c=FALSE (indicates hide, TRUE indicates show) d= row above where group starts Sam "Sam Wilson" wrote: Dear all, I've written some code that runs down a column and uses the data therein to group some rows together. All so far so good, but I want the default display to be with detail hidden. Any pointers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide/Show details in an Outline Group | Excel Discussion (Misc queries) | |||
How do I show or hide detail for a group in a protected worksheet | Excel Discussion (Misc queries) | |||
Macro to show/hide detail in an outline | Excel Discussion (Misc queries) | |||
hide detail / close group outline | Excel Programming | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) |