comments going haywire

[Guest]

I have been adding comments to various cells throughout a large spreadsheet.
However, whenever I add rows, the comments change size and location so that
they are suddenly all over the place.

1) Is there a way to prevent this?

2) Is there a way to fix this without manually moving/resizing every comment?

thank you for any help you can give me!
Jen

 

[Dave Peterson]

#1. Not that I know.

#2. The closest thing I know to control them is to just use a macro that resets
them
back to where they belong.

Debra Dalgleish has some code:
http://contextures.com/xlcomments03.html#Reset
http://contextures.com/xlcomments03.html#Resize

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]

that worked great, thanks!

#1. Not that I know.

#2. The closest thing I know to control them is to just use a macro that resets
them
back to where they belong.

Debra Dalgleish has some code:
http://contextures.com/xlcomments03.html#Reset
http://contextures.com/xlcomments03.html#Resize

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