VBA - Hide specific cell comments

[bernie69]

I would like to write cell comments in a worksheet that I have created that are meant for the administrator only. There are some comments in other cells that are meant for users.

Is there are way using VBA I can
a) assess the comments in a cell (e.g. the text starts with 'Admin:'). What property is this?
b) hide those comments so the user cannot view them

I have tried using the visible property but this doesn't do all I need it to. I do have a fallback option of using textboxes but this could end up looking a bit messy if there's lots of them!

Any help would be much appreciated.

 

[RichardMGreen]

This is a bit rough and ready (and untested) but it should get you started.

Sub test()
    Dim comm As Comment, ws As Worksheet
    For Each ws In Worksheets
        For Each comm In ws.Comments
            If Left(comm.Text, 5) = "Admin" Then
                comm.Visible = False
            End If
        Next
    Next
End Sub

 

[bernie69]

Thanks for this, is there any way of entirely hiding the comments box though? i.e. so the user can't hover over the cell and display the comment?

Thanks

 

[RichardMGreen]

I don't think so. Someone may have have found a way, but I've never been able to.