I had the same problem, heres the fix:
1. Click on Tools-Macro-Visual Basic Editor
2. Double Click on "This Workbook"
3. Insert the Following Code:
Private Sub Workbook_Open()
ActiveSheet.EnableOutlining = True
ActiveSheet.Protect contents:=True, userInterfaceOnly:=True
End Sub
4. Click Save.
The Workbook_Open() routine automatically runs when the workbook is
opened. The next time you open the workbook you should be able to use
the grouping functions on your protected worksheet!
--
joltinjoe02
------------------------------------------------------------------------
joltinjoe02's Profile:
http://www.excelforum.com/member.php...o&userid=15949
View this thread:
http://www.excelforum.com/showthread...hreadid=273169