Re: Hide columns in a group on after VBA-procedure

Worksheets("Sheet2").Outline _
.ShowLevels columnLevels:=1

--
Regards,
Tom Ogilvy


"NorTor" <toa@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0qi2c15nd9hro9peqlnnv57a5ptb467fvd@xxxxxxxxxx
> Hello!
>
> A bit of help needed please...
>
> On a reporting-***, I have selected some columns (F:J) and made them
> into a group (using menus DATA-GROUP). Now the user can select whether
> to view these columns by clicking the '+' symbol, and hide them again
> by clicking the '-' symbol.
>
> Now, the report is built by a VBA-procedure when the user clicks a
> 'Build Report' button.
>
> I would like the the group to be hidden by default after the report is
> built. The way it is now, the group is in the state the user left it
> before building the report.
>
> How do I add a line in the procedure so that the group/columns are
> hidden?
>
>
> Regards,
> -NorTor-
>


.

Loading