Enable Grouping Or Outline Or Outlining On A Protected Excel Worksheet

[paul_pearson]

Hi Excel Fox

Used the code below but still asks to unprotect sheet otherwise does not work

Private Sub Auto_Open()

    Dim wks As Worksheet
    
    For Each wks In Worksheets
        With wks
           .Protect Password:="YourPassWordHERE", UserInterfaceOnly:=True
           .EnableOutlining = True
        End With
    Next wks

End Sub