"Reset Comments"

[Sige]

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]

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

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

 

[Sige]

That's it !
Thanks a lot Debra

Brgds Sige