View Single Post
 
Old 08-20-2023, 02:15 PM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default 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
Reply With Quote