批量添加批注
Dim r As Range, msg As String
msg = InputBox("请输入批注内容", "提示", "标题文字")
If Selection.Cells.Count > 0 Then
For Each r In Selection
r.AddComment
r.Comment.Visible = False
r.Comment.Text Text:=msg
Next
End If
批量删除批注
Sub ClearComments()
Cells.Select '全选工作表
Selection.ClearComments '删除选区内的批注(单元格内容不变)
End Sub