调出VBE窗口,复制黏贴以下代码后,按F5执行就OK了:
Sub 批量修改批注框大小()
Dim Cmt As Comment
For Each Cmt In ActiveSheet.Comments
Cmt.Parent.Comment.Shape.Width = 150
Cmt.Parent.Comment.Shape.Height = 30
Next Cmt
End Sub
调出VBE窗口,复制黏贴以下代码后,按F5执行就OK了:
Sub 批量修改批注框大小()
Dim Cmt As Comment
For Each Cmt In ActiveSheet.Comments
Cmt.Parent.Comment.Shape.Width = 150
Cmt.Parent.Comment.Shape.Height = 30
Next Cmt
End Sub