How can I use open/close Grouped cells in a Protected Worksheet?

[Andy Bowshell]

Can anyone help me please - When I include Grouped cells in a Worksheet
by using "Data" / "Group and Outline", excell will not allow opening or
closing of the Grouped cells when the Worksheet is protected. Is there
an easy way I can open/close Grouped cells in a Protected Worksheet?

 

[Dave Peterson]

If you already have the outline/subtotals 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. (excel doesn't remember
it after closing the workbook.)

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

 

[Andy Bowshell]

Thanks Dave - I'll try what you say and Yes I'm not too well up o
Macros so I'll look at the reference you've suggested.

Thanks Agai