software

Hello!

Seems no matter what I try, I can't get comments to remain anchored within a
reasonable distance to their respective cells.

If I insert a comment in a cell and then enter it to edit, it will be
attached to the cell by a relatively short quot;umbilical cordquot;. If I then insert
rows or columns and enter the comment to edit it subsequently, the quot;umbilical
cordquot; and comment will move away from the cell some varying distance. I can
drag it back again, but next time I insert rows or columns again, the problem
will reoccur.

This is a problem only while editing the comment (the comment displays just
fine while the cursor is positioned in the cell.)

Both the quot;Move and size with cellsquot; and quot;Move but don't size with cellsquot;
properties seem to allow the greatest migration of the comment away from it's
cell; the quot;Don't move or size with cellsquot; property keeps it a little closer
to home, but still allows it to stray.

Thanks in advance for your help.

Chris

I think the best you can is put them back where they belong.

Debra Dalgleish has some code that can do it:
www.contextures.com/xlcomments03.html#ResetIf you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm
Chris wrote:
gt;
gt; Hello!
gt;
gt; Seems no matter what I try, I can't get comments to remain anchored within a
gt; reasonable distance to their respective cells.
gt;
gt; If I insert a comment in a cell and then enter it to edit, it will be
gt; attached to the cell by a relatively short quot;umbilical cordquot;. If I then insert
gt; rows or columns and enter the comment to edit it subsequently, the quot;umbilical
gt; cordquot; and comment will move away from the cell some varying distance. I can
gt; drag it back again, but next time I insert rows or columns again, the problem
gt; will reoccur.
gt;
gt; This is a problem only while editing the comment (the comment displays just
gt; fine while the cursor is positioned in the cell.)
gt;
gt; Both the quot;Move and size with cellsquot; and quot;Move but don't size with cellsquot;
gt; properties seem to allow the greatest migration of the comment away from it's
gt; cell; the quot;Don't move or size with cellsquot; property keeps it a little closer
gt; to home, but still allows it to stray.
gt;
gt; Thanks in advance for your help.
gt;
gt; Chris

--

Dave Peterson

Dear Dave Peterson:

I took a look at the resources you directed me to, and I'm certain that the
solution lies there. I'm gonna have to study it carefully, because anything
having to do with code or programming causes bleeding from my eyes and ears.
(quot;Damn It, Jim! I'm an Electrician, not a programmer!quot;) Ultimately, I think
I'll be able to navigate it.

Brief Rant: It makes me crazy when a product doesn't work. (Excel Comments
relocating themselves clearly falls into this category.) It's maddening to
have to go thru the gyration of fixing something like this, because having
already paid my money, I don't think the problem should be there in the first
place. Thank God for forums like this. (I'm done now.)

Although I haven't had the time to study the information and attempt the
fix, I just wanted to thank you very much for your help before the thread
goes South.

Thanx Again; hope you get this post……

Chris

quot;Dave Petersonquot; wrote:

gt; I think the best you can is put them back where they belong.
gt;
gt; Debra Dalgleish has some code that can do it:
gt; www.contextures.com/xlcomments03.html#Reset
gt;
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt;
gt;
gt; Chris wrote:
gt; gt;
gt; gt; Hello!
gt; gt;
gt; gt; Seems no matter what I try, I can't get comments to remain anchored within a
gt; gt; reasonable distance to their respective cells.
gt; gt;
gt; gt; If I insert a comment in a cell and then enter it to edit, it will be
gt; gt; attached to the cell by a relatively short quot;umbilical cordquot;. If I then insert
gt; gt; rows or columns and enter the comment to edit it subsequently, the quot;umbilical
gt; gt; cordquot; and comment will move away from the cell some varying distance. I can
gt; gt; drag it back again, but next time I insert rows or columns again, the problem
gt; gt; will reoccur.
gt; gt;
gt; gt; This is a problem only while editing the comment (the comment displays just
gt; gt; fine while the cursor is positioned in the cell.)
gt; gt;
gt; gt; Both the quot;Move and size with cellsquot; and quot;Move but don't size with cellsquot;
gt; gt; properties seem to allow the greatest migration of the comment away from it's
gt; gt; cell; the quot;Don't move or size with cellsquot; property keeps it a little closer
gt; gt; to home, but still allows it to stray.
gt; gt;
gt; gt; Thanks in advance for your help.
gt; gt;
gt; gt; Chris
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Good luck,

Chris wrote:
gt;
gt; Dear Dave Peterson:
gt;
gt; I took a look at the resources you directed me to, and I'm certain that the
gt; solution lies there. I'm gonna have to study it carefully, because anything
gt; having to do with code or programming causes bleeding from my eyes and ears.
gt; (quot;Damn It, Jim! I'm an Electrician, not a programmer!quot;) Ultimately, I think
gt; I'll be able to navigate it.
gt;
gt; Brief Rant: It makes me crazy when a product doesn't work. (Excel Comments
gt; relocating themselves clearly falls into this category.) It's maddening to
gt; have to go thru the gyration of fixing something like this, because having
gt; already paid my money, I don't think the problem should be there in the first
gt; place. Thank God for forums like this. (I'm done now.)
gt;
gt; Although I haven't had the time to study the information and attempt the
gt; fix, I just wanted to thank you very much for your help before the thread
gt; goes South.
gt;
gt; Thanx Again; hope you get this post……
gt;
gt; Chris
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I think the best you can is put them back where they belong.
gt; gt;
gt; gt; Debra Dalgleish has some code that can do it:
gt; gt; www.contextures.com/xlcomments03.html#Reset
gt; gt;
gt; gt;
gt; gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt; gt;
gt; gt;
gt; gt;
gt; gt; Chris wrote:
gt; gt; gt;
gt; gt; gt; Hello!
gt; gt; gt;
gt; gt; gt; Seems no matter what I try, I can't get comments to remain anchored within a
gt; gt; gt; reasonable distance to their respective cells.
gt; gt; gt;
gt; gt; gt; If I insert a comment in a cell and then enter it to edit, it will be
gt; gt; gt; attached to the cell by a relatively short quot;umbilical cordquot;. If I then insert
gt; gt; gt; rows or columns and enter the comment to edit it subsequently, the quot;umbilical
gt; gt; gt; cordquot; and comment will move away from the cell some varying distance. I can
gt; gt; gt; drag it back again, but next time I insert rows or columns again, the problem
gt; gt; gt; will reoccur.
gt; gt; gt;
gt; gt; gt; This is a problem only while editing the comment (the comment displays just
gt; gt; gt; fine while the cursor is positioned in the cell.)
gt; gt; gt;
gt; gt; gt; Both the quot;Move and size with cellsquot; and quot;Move but don't size with cellsquot;
gt; gt; gt; properties seem to allow the greatest migration of the comment away from it's
gt; gt; gt; cell; the quot;Don't move or size with cellsquot; property keeps it a little closer
gt; gt; gt; to home, but still allows it to stray.
gt; gt; gt;
gt; gt; gt; Thanks in advance for your help.
gt; gt; gt;
gt; gt; gt; Chris
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson