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.

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.

--
Regards,
Tom Ogilvy

"Tim Payne" wrote in message
...
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.

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.