Grouping while Sheet protected

[Barney Quinn]

Is there any way of allowing users to a shared worksheet to use the grouping
feature for my columns while the sheet is protected?

B

 

[Debra Dalgleish]

Because you can't change the protection in a shared workbook, you won't
be able to use the grouping feature on a protected sheet.

In a workbook that isn't shared, you can run a macro as the workbook
opens, to apply protection and allow grouping. Here's some sample code
posted by Dave Peterson:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub