Collapse/Expand groupings when sheet is locked

[antaeusguy]

I've created a form which has locked cells & unlocked cells. Unlocked cells are those fields which are intended for end users to fill in data.

All other cells are locked to prevent users from amending the formulas.

I've grouped some rows (e.g. row 2 to row 4). When I lock the sheet (only option is to select unlocked cells), I couldn't collapse/expand the groupings.

Because row 2 to row 4 contains formulas that I wouldn't allow end users to amend, I can't make these rows as unlocked. Even thou I unlocked it, I still can't collapse/expand...

Is there any other way to solve this issue? appreciate your help

 

[Datsmart]

To allow Grouping under a Protected Worksheet, it must be done each time the workbook is opened, so Workbook_Open event code is the place to do it.
Put code similar to this in the ThisWorkbook Module

Private Sub Workbook_Open()
    With worksheets("yoursheetname")
        .Unprotect "password"
        .EnableOutlining = True
        .Protect "password", contents:=True, userInterfaceOnly:=True
    End With
End Sub

Change "password" and "worksheet name" as needed.

 

[antaeusguy]

Cool! It worked! Thanks a lot for your kind help