Protect woksheet and keep using outline capabilities

[Jean-Luc]

Hello,

I need to share a worksheet and protect certain cells (preventing users to
replace formulas by values)
I tried to lock these cells and protect the worksheet.

Problem : when I do so, users can no longer use ouline "+" and "-" icons to
show or hide columns.

Could somebody help me ?

I am using Excel 2003

Many thanks and kind regards

 

[Dave Peterson]

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.)