I have a spreadsheet in Excel 2010 with grouped cells and numerous locked cells. I need to be able to insert comments into unlocked cells and expand and contract grouped cells within the locked spreadsheet. I have tried the following VBA code which allows for the expanding and contracting but does not let me insert comments.
Option Explicit
Private Sub Workbook_Open()
Sheets("2018").Unprotect Password:="Panadol1"
With Sheets("2018")
.Protect Password:="Panadol1", DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFormattingCells:=False, AllowFormattingColumns:=False, AllowFormattingRows:=False, userinterfaceonly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With
End Sub
Any help would be greatly appreciated.
Thanks.