PDA

View Full Version : [SOLVED] Enable use of "Grouping" with Excel 2000



malik641
09-04-2005, 12:52 PM
When a sheet is protected with grouped cells in Excel 2000, the user is unable to Expand and Collapse the Grouped cells. How can I enable that with a protected sheet on Excel 2000????

malik641
09-05-2005, 06:32 PM
I also noticed that this is the same for 2003.

Can anyone help me!?!?!

austenr
09-05-2005, 07:19 PM
Try unlocking the cells before you protect the sheet.

malik641
09-05-2005, 07:35 PM
No good....:mkay

malik641
09-06-2005, 04:47 AM
Got it. Thanks to Dave Peterson, the code is:



Option Explicit
Private Sub Workbook_Open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

Awesome :thumb