Locking cells but keeping Grouping Function available

[Cheriti]

I am trying to lock cells in a worksheet to protect the formulas but want the
users to still be able to use the grouping function already incorporated-
does anyone know how?

(I know how to lock only specific cells but when I do so it does not allow
the grouping function to expand or contract)

Thanks!

 

[Gord Dibben]

Private Sub Worksheet_Activate()
With Me
.Protect Password:="justme", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

This is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that sheet module. Edit if desired the Alt + q to return to
the Excel window.


Gord Dibben MS Excel MVP