Protection & Data Groups

[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?

 

[Debra Dalgleish]

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
'===================================