Locking from data entry but allowing oulining to function?

I would like to lock a set of rows and columns, but still allow the users to
use the grouping I have set on various spreadsheets. Is this possible? If
so, how to make it work, current if I lock any posrtion of the page, then
thry to use the grouping buttons... they tell me the data is locked and
protected.

You must have the DataGroup and Outline area pre-set.

Then you add event code to the worksheet module.

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

This will allow showing and hiding detail on a protected sheet.


Gord Dibben MS Excel MVP


On Fri, 26 Mar 2010 08:39:01 -0700, saharafrog
wrote:

I would like to lock a set of rows and columns, but still allow the users to
use the grouping I have set on various spreadsheets. Is this possible? If
so, how to make it work, current if I lock any posrtion of the page, then
thry to use the grouping buttons... they tell me the data is locked and
protected.