can I protect a worksheet but allow use of groupings (eg rows)
 

the topic says it all. When I protect a range of cells ina ny workbook excel
prevents use of the groupings feature. How do I get around this?

can I protect a worksheet but allow use of groupings (eg rows)
 

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Mike in Melbourne wrote:

the topic says it all. When I protect a range of cells ina ny workbook excel
prevents use of the groupings feature. How do I get around this?

--

Dave Peterson