Position of Notes (was Comments) when editing
I have soved the problem of Notes (Comments) wandering away from their parent cells with a simple VBA procedure . . .
For Each IndividualComment In ActiveWorkbook.Worksheets("NNN").Comments
IndividualComment.Shape.Top = IndividualComment.Parent.Top - 8
IndividualComment.Shape.Left = IndividualComment.Parent.Left + IndividualComment.Parent.Width + 11
Next IndividualComment
This places every Note (Comment) where I want it to be when I view it.
However, when I edit Notes, they sometimes open a long way away.
Is there a similar way to fix the placement of a note during editing ?
Thanks
|