Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
    
Can you add details about which version of Microsoft Excel you are using please. – Nick Josevski Jul 12 '11 at 8:07
    
@Nick Josevski : done, being busy with 2010 all this time makes me forget not everyone uses it – Terry Jul 12 '11 at 8:35
up vote 0 down vote accepted

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
share|improve this answer

You must log in to answer this question.

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