Prev: Counting specific letters in a cell
Next: split data into seperate worksheets by criteria
From: Ram B on 3 Jul 2008 11:39
Does anyone know how to protect a worksheet and still have access to the
"Group/Ungroup" functionality on the left ? Thanks!

From: Dave Peterson on 3 Jul 2008 12:58
If you already have the outline/subtotals/autofilter applied, you can protect
the worksheet in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
'.EnableAutoFilter = True
'If .FilterMode Then
' .ShowAllData
'End If
End With
End Sub

It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet, but that
won't help when you're filtering via code.)

Ram B wrote:
>
> Does anyone know how to protect a worksheet and still have access to the
> "Group/Ungroup" functionality on the left ? Thanks!

--

Dave Peterson
 | 
Pages: 1
Prev: Counting specific letters in a cell
Next: split data into seperate worksheets by criteria