Hide columns in a group on after VBA-procedure

[NorTor]

Hello!

A bit of help needed please...

On a reporting-sheet, 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-

 

[Tom Ogilvy]

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

 

[nortor]

Thank you so much Tom, just what I needed!


Regards,
NorTor