Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Hi all
I have a worksheet in which I have many groups set up.
This all works fine.
I would like to add a couple of buttons to give users the option to collapse all groups, and to expand all groups.
Can anyone help me with the code to do this please ?
I have done a search on this board, and found code that will CREATE the groups, but I don't need to do that.
I have also tried using the macro recorder while I collapse or expand a group, and no code seems to get recorded.
I'm using 2007.
Any ideas ?
Thanks in advance for any help !
I have a worksheet in which I have many groups set up.
This all works fine.
I would like to add a couple of buttons to give users the option to collapse all groups, and to expand all groups.
Can anyone help me with the code to do this please ?
I have done a search on this board, and found code that will CREATE the groups, but I don't need to do that.
I have also tried using the macro recorder while I collapse or expand a group, and no code seems to get recorded.
I'm using 2007.
Any ideas ?
Thanks in advance for any help !