How can I group/outline UP using VBA

  • Thread starter Thread starter riopapa
  • Start date Start date
R

riopapa

By using Selection.rows.group, [-] icon comes at the bottom of the
selection.
It might be usefull when we have several lines followed by total.
But, I want to use grouping function for WBS(work breakdown
structure).
[-] MyMoving
[-] Pack furnitures
. Pack Dining Room
. Pack Bed Room 1
. Pack Bed Room 2
....
[-] Load into Moving Car
. Stuffs from Dining Room
. Stuffs from Bed Room

In other words, I want use Excel like MS Project summary tasks.

Is there any way to implement this?
 
I don't use MSProject, but in xl2003 menus, I can use:

Data|Group and Outline|Settings|uncheck "Summary rows below detail"

If that's what you want, you could record a macro when you did it manually to
get the code.
By using Selection.rows.group, [-] icon comes at the bottom of the
selection.
It might be usefull when we have several lines followed by total.
But, I want to use grouping function for WBS(work breakdown
structure).
[-] MyMoving
[-] Pack furnitures
. Pack Dining Room
. Pack Bed Room 1
. Pack Bed Room 2
....
[-] Load into Moving Car
. Stuffs from Dining Room
. Stuffs from Bed Room

In other words, I want use Excel like MS Project summary tasks.

Is there any way to implement this?
Click to expand...
 
Back
Top