Hi,

I'm using excel 2000 and I'm trying to memorize the current outline to
be able to restore it later.

I tried this on the following sheet, the 3 "a"s are grouped and the 3
"b"s to.

a 1
a 2
a 3
b 1
b 2
b 3


Sub TEST()
Dim PLAN As Outline

Set PLAN = ActiveSheet.Outline ' memorize the outline
ActiveSheet.Outline.ShowLevels 2 ' modify it
MsgBox "hello"
Set ActiveSheet.Outline = PLAN ' want to restore it
' but get an error
here
End Sub


I am able to memorize the current outline but I am not able to restore
it ...

Anyone has an idea of how to proceed ?

Thanks for any hints.

René.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/