Excel - grouped data and protected sheet

Occasional Visitor

Hi there! help please? have grouped data in worksheets but when the sheets are protected - not able to expand the grouped fields. tips please? would so appreciate.

1 Reply


One suggested solution is that you could use VBA to accomplish this.

Here is a small example with a sample file.

Sub Workbook_Open()
ActiveSheet.Protect userinterfaceonly:=True, Password:="group"
ActiveSheet.EnableOutlining = True ' for outlining
ActiveSheet.EnableAutoFilter = True ' for auto filter
End sub

You can see in this code, is highlighted the word "group" in blue.

This is the password, which you can of course change.


Hope I was able to help you with this information.



I know I don't know anything (Socrates)