Secured excel sheet cannot expand/collapse grouped columns

Question

We have an Excel spreadsheet with a secured/protected sheet. Only a small number of cells are open for editing. Now that it is protected, we cannot expand or collapse the columns in that sheet anymore.

Is there a way to do this, or can't this be done at all?

Answer 1

According to this post on Microsoft Answers, you cannot expand or collapse grouped columns in a protected sheet.

It is possible to write a macro to show or hide the columns, rather than using grouping to do it, and then attaching the macro to a button on the sheet, as in the suggestion from that site:

Sub HideorUnhideColumns()
Sheets("Sheet1").Activate
If Columns("A:D").EntireColumn.Hidden = True Then
   Columns("A:D").EntireColumn.Hidden = False
Else
   Columns("A:D").EntireColumn.Hidden = True
End If
End Sub