Protection & Data Groups

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

In older versions of Excel, I can create a Grouped set of
columns or rows, password protect the sheet and am able to
expand (+) or collapse (-) the Groups.
In Excel 2002, once you protect a sheet, you can no longer
expand or collapse Groups. It does not matter what
combination of protection selections you choose or whether
or not the Grouped cells are locked.
I think this is a bug. Has anyone encountered it?
 
AFAIK, no recent version of Excel allows you to use outlining buttons on
a protected worksheet.

If you protect the worksheet programmatically, you can enable outlining.
For example, the following code protects the sheet named "Data", and is
stored on the ThisWorkbook module:

'===================================
Private Sub Workbook_Open()
With Sheets("Data")
.EnableOutlining = True
.Protect Password:="pwd", _
UserInterfaceOnly:=True
End With
End Sub
'===================================
 
Back
Top