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

@Audrey1818 

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.

 

NikolinoDE

I know I don't know anything (Socrates)