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

On Fri, 5 Sep 2008 14:54:01 -0700, Ryan
wrote:

I want to protect a worksheet but still be able to hide and show groups but
cant seem to figure out how. Is it possible to do?