Grouping on a protect sheet

[cgreen3]

Allright I have searched and tried to get this too work in my worksheet

Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="xlhelp", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

Im trying to have my grouping expand on my protected sheet and it will not work for me. If I could have some help on this I would really appreciate it.

 

[SkipVought]

Hi,

Please post VBA code questions in forum707.

The short answer is in your code...
[tt]
Unprotect the sheet
Do your sheet modifications
Protect the sheet
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}