Comments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 20 Dec 2007 14:27 GMT

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?

Reply to this Message

Dave Peterson - 20 Dec 2007 14:40 GMT

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

> 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
[quoted text clipped - 4 lines]
> place. So does anyone know how to get the comments back to the original cell
> if they are shown?

Signature

Dave Peterson

Reply to this Message

Rate this thread: