Using Group and Outline with Protected Cells

  • Thread starter Thread starter Cbruns
  • Start date Start date
C

Cbruns

I am trying to protect certain cells in a worksheet that contains numerous
groupings (Group and Outline function). However in order to protect the
cells, I have to protect the worksheet. When I protect the worksheet, its
telling me I can not use the grouping function with a protected worksheet.
Is there anyway to protect cells and still use the grouping feature? Thanks
 
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.)
 
Back
Top