I need to protect certain cells of an Excel 2010 sheet. I also need to enable users to Expand/Collapse Row and Column groupings. I searched and found the code below. The code was placed in the worksheet for which I would like the protection with groupings enabled. It did not work.
My files are supposed to go out today so 500 pts if someone can help me get this nailed.
Thanks in advance!!
Private Sub Worksheet_Activate()
.Protect Password:="Lockthis", userinterfaceonly:=True
.EnableOutlining = True