hello
i am trying to disable comments altogether.
namely prevent the user from entering comments in a
workbook.
please help.Code:Sub nocomments()
Dim ws As Worksheet
Dim cell As Range
For Each ws In ActiveWorkbook.Worksheets
cell.Comment.Visible = False
MsgBox "no comments"
Next
End Sub
thanks