Windows browser Parent/Child structure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ERK - 02 Dec 2006 19:50 GMT

Is it possible to setup a cell structure such that when I click on it a "Windows browser Parent/Child structure" opens and closes?
Similar to the folders with the "-" and "+" signs of the browser? His means that an entire set of rows appear or disappear by clicking on the cell?
If so, could you please point me in the right direction so I can do this.

Thanks
Erich

Reply to this Message

Gord Dibben - 02 Dec 2006 20:19 GMT

Maybe Data>Group and Outline>Group will work for you.

See help on that subject for more info.

Or possibly set up a PivotTable for grouping.

Or use Data>Filter>Autofilter to show rows with your criterion.

As far as clicking on a cell to achieve your ends, you would need event code to
look after that.

Gord Dibben MS Excel MVP

>Is it possible to setup a cell structure such that when I click on it a "Windows browser Parent/Child structure" opens and closes?
>Similar to the folders with the "-" and "+" signs of the browser? His means that an entire set of rows appear or disappear by clicking on the cell?
>If so, could you please point me in the right direction so I can do this.
>
>Thanks
>Erich

Reply to this Message

ERK - 03 Dec 2006 00:44 GMT

Thanks a lot, took a quick look and it has the potential of doing what I
want.
I will look at the help.

Thanks,
Erich

Reply to this Message

Rate this thread: