Group and Outline
 

Upon protecting a worksheet I find I am unable to collapse or expand grouped
rows in a worksheet.
Is there a way to accomplish this without unprotecting the worksheet? It is
used by 44 people and we need to have the cells with formulas protected?
Thanks for any help
Marsh

Group and Outline
 

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


Marsh wrote:

Upon protecting a worksheet I find I am unable to collapse or expand grouped
rows in a worksheet.
Is there a way to accomplish this without unprotecting the worksheet? It is
used by 44 people and we need to have the cells with formulas protected?
Thanks for any help
Marsh

--

Dave Peterson

Group and Outline
 

Thank you.
The link was very helpful.

"Dave Peterson" wrote:

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


Marsh wrote:

Upon protecting a worksheet I find I am unable to collapse or expand grouped
rows in a worksheet.
Is there a way to accomplish this without unprotecting the worksheet? It is
used by 44 people and we need to have the cells with formulas protected?
Thanks for any help
Marsh

--

Dave Peterson