Comments

[Richard]

I have several thousand rows and some cells have comments in them and every
time I edit anything it drop or raises all my comments, I have Excel 2002,
what can I do about
this?

Richard

 

[Markv]

Hi there.

Hope the following helps;;;

On the menu on top select TOOLS, then move down to select OPTIONS and in the
next window that pops up select the VIEW tab, under comments check the small
radio button named NONE. click ok

 

[Gord Dibben]

Not sure what you're describing or expecting for a solution but maybe
re-position Comments to default?

This from Debra Dalgleish.


Reset Comments to Original Position
If comments have moved out of position, you can reset them using the following
code:


Sub ResetComments()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
Next
End Sub


Gord Dibben MS Excel MVP