Grouping in a protected sheet

  • Thread starter Thread starter Werner Rohrmoser
  • Start date Start date
W

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