Dear board,
In my file I have grouped some lines. In total I have 4 subgroups within each mastergroup.
Now I would like to add a button to collaps some of the mastergroups. My first intention was to do this very simple via hide/unhide. However, if some of the groups where collapsed before I hide all, they are all expanded again when I Unhide these rows. Indeed it seems logical that it is being done this way, since that is what I ask, but it is of course not what I want. when I do the unhide, I would like to have the same view again as before. When using the macro recorder, I don't see any coding returned.
Hopefully I explained this more or less clear. Is there someone out here who can help me with this?
Thanks!
shodan
In my file I have grouped some lines. In total I have 4 subgroups within each mastergroup.
Now I would like to add a button to collaps some of the mastergroups. My first intention was to do this very simple via hide/unhide. However, if some of the groups where collapsed before I hide all, they are all expanded again when I Unhide these rows. Indeed it seems logical that it is being done this way, since that is what I ask, but it is of course not what I want. when I do the unhide, I would like to have the same view again as before. When using the macro recorder, I don't see any coding returned.
Hopefully I explained this more or less clear. Is there someone out here who can help me with this?
Thanks!
shodan