How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific c

  • Thread starter Thread starter Anurag Kothari
  • Start date Start date
A

Anurag Kothari

Hi,

I am preparing a template where there are few sheets having
functionality of grouping and ungrouping of rows. I am using below
code for protecting and is working well:

Private Sub Worksheet_Activate()
With Me
..EnableOutlining = True
..Protect "XXX", UserInterfaceOnly:=True
End With
End Sub

Now in a specific sheet I also want to provide user the ability to
change the colour of the specific cells.

Please let me know how to update the above code to support the
requirement.

Any support is much appreciable !!!

-Anurag
 
Private Sub Worksheet_Activate()
With Me
..EnableOutlining = True
..Protect "XXX", AllowFormattingCells:=True
End With
End Sub
 
Private Sub Worksheet_Activate()
With Me
.EnableOutlining = True
.Protect "XXX", AllowFormattingCells:=True
End With
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...

Hi Luke,

Thanks for the code but I am unable to group and ungroup rows after
using the given code.

Regards,
Anurag
 
Back
Top