0

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?

Improve this question
2
  • Can you add details about which version of Microsoft Excel you are using please.
    – Nick Josevski
    Jul 12, 2011 at 8:07
  • @Nick Josevski : done, being busy with 2010 all this time makes me forget not everyone uses it
    – Terry
    Jul 12, 2011 at 8:35

1 Answer 1

Reset to default
0

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
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .