#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
As no-one has been able to answer, is it OK is I cross-post this ?
Thanks, Martin |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get the position of a string from the cursor position forward | alex100 | Word VBA | 2 | 02-22-2023 02:48 AM |
Multiple editing restrictions - allow comments with other restrictions | naderfikry | Word | 6 | 08-08-2017 05:41 AM |
PowerPoint 2013-Position and formating of Notes Text Box | Desiderata | PowerPoint | 0 | 03-14-2017 01:31 PM |
Textboxes position isn't equal to initial position | dxdevil | Word VBA | 0 | 01-30-2017 04:32 AM |
Restrict editing: allowing forms, tracked changes AND comments | andylaw31 | Word | 1 | 08-14-2015 03:13 PM |