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