Comments not anchored to cells

[Guest]

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 "umbilical cord". If I then insert
rows or columns and enter the comment to edit it subsequently, the "umbilical
cord" 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 "Move and size with cells" and "Move but don't size with cells"
properties seem to allow the greatest migration of the comment away from it's
cell; the "Don't move or size with cells" property keeps it a little closer
to home, but still allows it to stray.

Thanks in advance for your help.

Chris

 

[Dave Peterson]

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

Debra Dalgleish has some code that can do it:
http://www.contextures.com/xlcomments03.html#Reset


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

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.
("Damn It, Jim! I'm an Electrician, not a programmer!") 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

 

[Dave Peterson]

Good luck,

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.
("Damn It, Jim! I'm an Electrician, not a programmer!") 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