Comments

[Richard]

I have a hundred comments and then I edited the entire spreadsheet and now
when I show my comments they are hundreds of rows down. Anyway how can I get
them to the right cell? If I hide the comments and run my mouse over the
cell the comments they are find, only when I show them they are stung all
over the place which would take me many hours to get them back to their
original cell and then if I edit again then there they go again all over the
place. So does anyone know how to get the comments back to the original cell
if they are shown?

 

[Dave Peterson]

You can use a macro to put them back to their original positions:

http://contextures.com/xlcomments03.html#Reset
(From Debra Dalgleish's site)

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