Hi TWIMC,

Same question as yesterday.

I have a Access program that creates a workbook and populates it with data,
I then group the data based on the number of levels normally 6 but could
differ. I then want to collapse all levels, but then want to show the data at
level 2.

Now yes this command shows the data at level 2
ws.Outline.ShowLevels RowLevels:=2

but if you click on level 3, the other levels below level 3 are also
displayed. Thus the view I'm after is that if a user clicks on level 3, level
4 levels ? and ? still remain collapsed.

any help much appriciated
regards
KM