how to control outline group? show or collapse [vba]

[riopapa]

I made an project tasks and outlined for each level thru vba.
How can I hide (make it [+]) all the summary tasks if completed?
..showdetail = false looks not working as I wanted

[1][2][3] Task Name %Done Start,
Finish, ..........
[-] My Project 30
[-] High Level 1st 100
. Task 1 100
. Task 2 100
[-] High Level 2nd 10
. Task 3 20
. Task 4 0
. Task 5 0
......

In above example, High Level 1st has been done, so I want to hide.
Range("A3:A5").showdetail = false or Range("A4:A5").showdetail =
false doesn't work.
Any idea to hide High Level 1st & below level tasks?

 

[Dave Peterson]

Look for ShowLevels in VBA's help.

I made an project tasks and outlined for each level thru vba.
How can I hide (make it [+]) all the summary tasks if completed?
.showdetail = false looks not working as I wanted

[1][2][3] Task Name %Done Start,
Finish, ..........
[-] My Project 30
[-] High Level 1st 100
. Task 1 100
. Task 2 100
[-] High Level 2nd 10
. Task 3 20
. Task 4 0
. Task 5 0
.....

In above example, High Level 1st has been done, so I want to hide.
Range("A3:A5").showdetail = false or Range("A4:A5").showdetail =
false doesn't work.
Any idea to hide High Level 1st & below level tasks?