Uncollapse Grouped Rows on a Proctected worksheet

[Tanya]

I have grouped rows on a worksheet then protected the
worksheet to prevent users from inserting rows.

I would like to collapse the rows so the user only sees
the group descriptions. I would then like them to
uncollapse the group they wish to enter in.

Any suggestions?

Thanks.

 

[Dave Peterson]

This setting isn't remembered between closing/reopening the workbook. (So
Auto_open is a nice spot for it.)

Option Explicit
Sub auto_open()

Dim wks As Worksheet
Set wks = Worksheets("sheet1")

With wks
.Protect Password:="hi", userinterfaceonly:=True
.EnableAutoFilter = True
'or
.EnableOutlining = True
End With

End Sub

EnableAutofilter/enableoutlining--depending on what you mean by grouped.

And autofilter or the outlining has to already be applied.