Wow! I created two macros (ResetComments and ResizeComments) and they are
awesome! Only problem is ResetComments macro doesn't work if I click the
AutoFilter button in a column, select a specific item from the drop down and
Right-clicking to Edit Comment creates - I still get the long pointer and see
the comment elsewhere on the worksheet. Any fix for that?

PREVIOUS DISCUSSION copied he
Put them back where they belong with a macro???

From Debra Dalgleish's site:
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

gillilal wrote:

comments do not move with the cell they were created on and has long pointers
to them in the worksheet. They are stationary and not floating with the cell
if moved. So the comment may be several pages away from its intended
location. Any suggestions?

--

Dave Peterson