Thanks Norman, that's fantastic.

cheers
big t

***********************

"Norman Jones" wrote:

Hi BigT,

See the EnableOutlining property in VBA help.

If you apply protection setting UserInterfaceOnly and EnableOutlining to
true, you can protect the worksheet(s) and yet enable access to the
outlining feature for the user, e.g.:

Sub Tester()
Dim SH As Worksheet

For Each SH In Me.Worksheets
With ActiveSheet
.Select
.EnableOutlining = True
.Protect Password:="drowsap", _
Contents:=True, _
UserInterfaceOnly:=True
End With
Next SH

End Sub

Such protection is not persistent (it reverts to normal protection) and
therefore such code might be placed in the workbooks open event,


---
Regards,
Norman



"big t" wrote in message
...
hi everyone,

I have a worksheet where I have grouped certain rows (using Data...Group
and
Outline...Group) so I have some + and - signs down my left hand margin.

But when I protect the sheet I can't upgroup the rows!!! And there doesn't
seem to be an option for it under Tools..Protection...Protect Sheet.

Any ideas???


TIA
big t