View Single Post
  #3   Report Post  
joltinjoe02
 
Posts: n/a
Default


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