Toggle Comments : Cell Comments « Excel « VBA / Excel / Access / Word






Toggle Comments

 
Sub ToggleComments()
    If Application.DisplayCommentIndicator = xlCommentAndIndicator Then
        Application.DisplayCommentIndicator = xlCommentIndicatorOnly
    Else
        Application.DisplayCommentIndicator = xlCommentAndIndicator
    End If
End Sub

 








Related examples in the same category

1.Get the comment text
2.Converts docstring column into comments on name column.
3.Tracking cell changes in a comment
4.Clean the comment
5.resize Comments
6.Count Comments