ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comment position..?? (https://www.excelbanter.com/excel-discussion-misc-queries/2669-comment-position.html)

RJH

Comment position..??
 
Hello,
I have a problem with a couple of comment boxes (all the rest are fine).
They are WAY across the sheet from where they belong and all attempts to
reel them in have failed. When you cursor over the cell, you get tossed
across the sheet to where the comment likes to hang out. When you
right-click and edit or show the comment it sits nicely beside the cell it's
assigned. Has anyone seen this sort of thing or know how to correct it?
Windows XP Pro
Excel 2000

Thanks!

RJH



Dave Peterson

You could use the code at Debra Dalgleish's site to put those comments where
they should be:

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

RJH wrote:

Hello,
I have a problem with a couple of comment boxes (all the rest are fine).
They are WAY across the sheet from where they belong and all attempts to
reel them in have failed. When you cursor over the cell, you get tossed
across the sheet to where the comment likes to hang out. When you
right-click and edit or show the comment it sits nicely beside the cell it's
assigned. Has anyone seen this sort of thing or know how to correct it?
Windows XP Pro
Excel 2000

Thanks!

RJH


--

Dave Peterson


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com