Allow Group and outline on protect sheet

[verada]

Loungers, I need to be able to allow a user to group and ungroup rows on a protected sheet.

I assume that some sort of code is required or if there are any other solutions

If anyone has any suggestions/expample of code to do this, it woudl be much appreciated.

(I thought I posted this yesterday - but cant seem to find the post in the lounge)

[sdckapr]

Add this to the ThisWorkbook Object in VBA:

Option Explicit
Private Sub Workbook_Open()
  With Worksheets("MySheet")
    .Protect Password:="MyPassword", UserInterfaceOnly:=True
    .EnableOutlining = True
  End With
End Sub

Change the worksheet name and password as appropriate. The parameters are reset after the workbook is closed so it must be done when the workbook is opened.
Steve