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
Bookmarks