Comment boxis not showing to near the related cell

[krishnakuma6]

Dear Experts,

I have worksheet with 5000 rows data's including the comments in one coloumn.My problem is when I edit the comments,the comment box shows somewhere else is not showing to near the related cell.I am using excel 2007,its happen after the upgradation of 2003 to 2007.Pls someone to help on this

[dilipandey]

Hi Krishna,

This usually happens when you have opted to "show" your comment and then sometimes these comments moves far away

Try below code:-

Please Login or Register  to view this content.

Note:- you can play with 50 and 20 in above code to further position comments boxes

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Hi Krishna,

This usually happens when you have opted to "show" your comment and then sometimes these comments moves far away

Try below code:-

Please Login or Register  to view this content.

Note:- you can play with 50 and 20 in above code to further position comments boxes

Regards,
DILIPandey

<click on below 'star' if this helps>