Grouping in a protected sheet in excel 2003 1

[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. Other users will be using this sheet so It will have to be protected while still having the grouping function. If I could have some help on this I would really appreciate it

 

[SkipVought]

Hi,

What did you do with my short answer explanation, to programatically unprotect, modify the sheet and then protect?

Skip,

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

 

[cgreen3]

That would work for my personal use but other users will be using this sheet and need that grouping function but I will need to have some cells locked to keep my standards in place.

Thank you
I appreciate the help

 

[SkipVought]

Put your standards on a hidden sheet. This is standard worksheet protocol, no code required.

Skip,

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

 

[cgreen3]

The way my boss wants it is to have the standards on the sheet.
For example I would have the product then in that cell for that product have a drop down list that you would pick the type of product and in the the next cell the standard for that product would pop up.

Now in a day that supervisor could produce "Hams" but within the hams could be black forest ham etc and that would produce multiple rows so I used grouping to clean up the sheet a bit so it would print on one sheet.
After inserting
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="xlhelp", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
and then protecting my sheet I can not use the grouping function maybe I'm putting it in the wrong place or not turning something on.

Thanks

 

[SkipVought]

The way my boss wants it is to have the standards on the sheet.

Well you boss might want the moon to consist of green cheese, but that will not make it so.

I suspect that the reason for this requiement, is to accomodate the Data > validation - LIST DropDown YES???

If that's the case, you can STILL have the reference lists, standards or whatever data you want to protect on a hidden sheet, using Named Ranges to name the lists.

Here are your choices:

1. Protected sheet, with limited editing available to users.

2. Unprotected sheet, with sensative data on a hidden sheet.



Skip,

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

 

[combo]

Is the auto_open procedure in standard module? Are the macros enabled (chech security level)?

combo