"Reset Comments"
 

Hi There,


I have spreadsheets with comments on it ... which are "shown" /
visible.
But by playing with the spreadsheet somehow:
inserting rows/ columns, scrolling, freeze panes ,...Actually I cannot
recreate the issue right now!

The comments appears a couple pages further (read a LOTTTTt of rows
...columns further) than next to cell where they had been inserted.

IS it possible to "reset" the comments ...so that they stand nicely
next to their cell again?

Brgds Sige

"Reset Comments"
 

There's sample code here that will reset comments to their original
position:

http://www.contextures.com/xlcomments03.html#Reset

Sige wrote:
Hi There,


I have spreadsheets with comments on it ... which are "shown" /
visible.
But by playing with the spreadsheet somehow:
inserting rows/ columns, scrolling, freeze panes ,...Actually I cannot
recreate the issue right now!

The comments appears a couple pages further (read a LOTTTTt of rows
..columns further) than next to cell where they had been inserted.

IS it possible to "reset" the comments ...so that they stand nicely
next to their cell again?

Brgds Sige



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"Reset Comments"
 

That's it !
Thanks a lot Debra

Brgds Sige