Hi All,
I'm trying to resize a note field using VBA, i recorded a macro to do what i wanted but if fails after adding the note.
The code below is what the recorded macro is for adding and resizing a basic note.
Any idea's ???
Code:
Sub Macro18()
Range("W12").AddComment
Range("W12").Comment.Visible = False
Range("W12").Comment.Text Text:="Me:" & Chr(10) & ""
Selection.ShapeRange.ScaleWidth 1.95, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 2.12, msoFalse, msoScaleFromTopLeft
End Sub