Hiding All Groups

[Tim Payne]

I have a macro that generates some reports and adds groups for drill downs.
Is there a simple way to have Macro collapse all of the groups when it's
finished? I've tried using .Hidden = true as I generate the regions, but
that only appears to collapse the top level, when you open the top level,
all of the bottom levels are still open.......

Regards,

Tim.

 

[Tom Ogilvy]

Can you do it manually. If so, then turn on the macro recorder while you do
it.

Otherwise, I think you will have to loop to find your groups and do the
hiding. Again, the macro recorder should come in handy to get the code.

 

[Tim Payne]

Hi Tom,

Thanks for the advice, I've managed to get it to loop through each level and
close by recording pressing the group buttons at the top of the grouping
columns!



Tim.