Enable Grouping Or Outline Or Outlining On A Protected Excel Worksheet

[Excel Fox]

A lot of times we come across situations where we need to use the Grouping / Outlining feature in Excel, but at the same time we want to protect the sheet too. Excel doesn't provide an option to do this via the sheet protection window that pops up while protecting a sheet. However, this can easily be achieved using VBA. Here's how (paste it in a module)


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

[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