Grouping in a protected sheet

[Werner Rohrmoser]

Hello,

Application: Excel XP SP2
OS: Win XP 5.1.2600 SP1

Is it possible to group and ungroup in a protected sheet.
I tried several approaches provided by the sheet protection dialog,
but I didn't succeed.

Hiding and unhiding rows is possible, even in a protected sheet,
and therefore I thought it should be possible to group and ungroup
in a protected sheet as well.

Regards
Werner

 

[Dave Peterson]

If you already have the outline 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

(I wasn't sure what caused your outlining--data|Group or Data|subtotals).)

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

 

[Werner Rohrmoser]

Thanks a lot Dave,
your solution matches excatly my problem.

Werner