protect sheet with freedom of group/ungroup

[javaidmr]

dear all

once i "protect sheet" , i can not group / ungroup the column / row. after protecting sheet, i want the freedon to group/ungroup the column.

[Richard Buttrey]

Hi,

Maybe use a macro to toggle sheet protection. There doesn't appear to be a switch in the sheet protection functionality to ignore grouping.

[CoachFogg]

I had this same problem. Here is what I did:

Push Alt+F11 to start the "Visual Basic Editor"
Double-click "ThisWorkbook"
A module will pop up. Copy and paste the code below:

Private Sub Workbook_Open()
With Worksheets("Emp Summary")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With
End Sub

That should do it!

- Coach Fogg