Apr 01 2022 12:04 PM
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.
Apr 02 2022 02:40 AM
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)