I have code that standardizes all comment boxes but is it possible to isolate this for one cell?
The reason I'd like this is because boxes are getting squished flat or distorted when moved around even if "locked"
This is what I have:
Sub Comments_Format()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Width = 800
cmt.Shape.Height = 450
Next cmt
End Sub
The reason I'd like this is because boxes are getting squished flat or distorted when moved around even if "locked"
This is what I have:
Sub Comments_Format()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Width = 800
cmt.Shape.Height = 450
Next cmt
End Sub
Last edited: