How to enable grouping in a protected sheet

A

Ankur

I am using grouping and ungrouping of cells. I want to protect few cells in
the sheet. So when I protect the sheet, I no more can group or ungroup the
cells. Do we have a solution for this
 
J

joltinjoe02

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 i
opened. The next time you open the workbook you should be able to us
the grouping functions on your protected worksheet
 
Top