Cell comments

[Sahak]

Hi all
I work on Excel 2016. Lately I find out that on worksheet, where I have many comments on cells, all previously hided comments after a while, (to be honest I have no idea after what taken action or how long time it takes), all cells having comments, become visible (not hidden), any idea?

Also, is there any way or VBA code to hide comments on more than one cell at once.

Thank you in advance.

 

[Tom Urtis]

This will hide all your active sheet's comments at once per your last sentence that begins with Also.

I could not understand exactly what that first paragraph means.

Sub HideAllComments()
Dim intCellCount%, cell As Range
On Error Resume Next
intCellCount = Cells.SpecialCells(1).Count
If Err.Number <> 0 Then
Err.Clear
Exit Sub
Else
For Each cell In Cells.SpecialCells(1)
cell.Comment.Visible = False
Next cell
End If
End Sub

 

[Sahak]

Thank you Tom very much for your help (including the code to hide all comments )
In first paragraph I mean: I'm hiding all comments, but somehow after wile, they become visible automaticaly it selfs, maybe something was changed in Excel Options (settings)