Hi,

I have a protected sheet which I want people to be able to insert/delete rows as well as formating cells etc. I also have a Macro running on this sheet to allow group and ungrouping to happen while the sheet is protected.

But when I close the workbook and re-open all the permissions on the protected sheet have disappeared... ie. the sheet is still protected but i can no longer insert/delete rows etc.

I assume it is the Macro that is removing this... is there a way to stop this from happening??

Any help would be greatly appreciated!

Ben

The Macro I am currently using if needed is:

Private Sub Workbook_Open()
With Sheet5
.Protect Password:="Password", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub