Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grouping in a protected sheet in excel 2003
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...- cgreen3
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Grouping in a protected sheet in excel 2003
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- cgreen3
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Grouping in a protected sheet in excel 2003
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...- cgreen3
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Grouping on a protect sheet
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...- cgreen3
- Thread
- Replies: 1
- Forum: Microsoft: Office
