View Single Post
  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

Could they text boxes or validation instead of comments. Do you shave
comment indicator turned on.

You have no control over where Excel will show the comment, or even if it will
be visible. You might have some luck using
Reset Comments to Original Position
http://www.contextures.com/xlcomments03.html#Reset
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"deo89" wrote in message ...
Maybe I'm dense, but I have a large shared spreadsheet with lots of comments.
For some (not all) of the comments, it will not allow any editing in the
comment cell. In addition, some (not all) comments will anchor themselves
near column BS even though the comment is for a cell in colum AA?

Any help?