Allow specific users to edit objects "comments". Restrict all other users.

[Brttcx]

Good evening,
I'm struggling with this one. I have given my sheet user specific permissions to edit the range of cells. After protecting the sheet, all users are still able to edit comments. I want to restrict all users from editing comments, and allow only those who I gave "edit" permissions to rights to edit an "object".

I have tried to deselect "edit objects" when I protect the sheet, but this restricts all users from adding comments. Is there any way to do this? I'm comfortable with VBA as well, the only catch is it is a Shared Workbook, so I'm not sure what compatibility issues I might have. Thank you!

 

[Yongle]

You could try something like this
- apply different protection according to user when file is opened

For simplicity of illustration sheet protection paramaters limited - amend to suit your needs
(record a macro when you set protect paramaters and use that to guide you)

[I][COLOR=#000080]Workbook_Open must be placed in ThisWorkbook module[/COLOR][/I]
Private Sub Workbook_Open()
    Call WhichUser
End Sub

Sub WhichUser()
    Dim usr As Variant
    With Sheets("Sheet1")
        .Unprotect "password"
            For Each usr In Array("yongle", "john", "peter")
                If Application.UserName = usr Then
                    .Protect "password", DrawingObjects:=False, Contents:=True, Scenarios:=True
                Else
                    .Protect "password", DrawingObjects:=True, Contents:=True, Scenarios:=True
                End If
            Next
    End With
End Sub