Cell's comment goes down when editing

[satucha]

Hi,

I have a problem with right-down moving cell's comment. I'm using
auto-filter. When I want to edit cell's comment, comment goes down and
right in the sheet. Then I can edit and close the comment.
Unfortunately, I staied in right-down position in the sheet and I have
to press Ctrl+Home (or use slidebar) to get back to left-up position in
the sheet. Everything works properly without autofilter.

Please help me to solve it.

Thanks in advance

Satucha

 

[Dave Peterson]

How about a small macro that resets the comment position for the cells that are
still visible:

Option Explicit
Sub ResetComments()

Dim cmt As Comment

For Each cmt In ActiveSheet.Comments
If cmt.Parent.EntireRow.Hidden Then
'do nothing
Else
cmt.Shape.Top = cmt.Parent.Top + 5
cmt.Shape.Left = _
cmt.Parent.Offset(0, 1).Left + 5
End If
Next cmt

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm