Thanks Nick,
unfortunately this does not appear to fix my problem.
I have discovered that if I programatically place the comments where I want
them and make them all visible they appear where I want them, except then
when I mouse over the cells that the comments are tied to the cells snap back
to the default position. (Which is not where I need them)

Jeff

"NickHK" wrote:

Jeff,
maybe you can tailor this to your needs:
With Range("A1")
.Comment.Shape.Left = .Left + .Width
.Comment.Visible = True
End With

NickHK

"Jeff M" wrote in message
...
I have an excel workbook with comments on all items in column A.
I have a screen split between column A & B so that I can scroll through
the
columns keeping column A visible.
Unfortunately when I scroll too far to the right the comments no longer
are
visible.
(ie When I scroll to column N I can still see column A, but even with the
mouse on column A the comments are not visible, until I scroll back to the
left)

I am looking for a VBA macro that I can use to fix this problem.
I suspect it will use the .scrollcolumn property but frankly I am stuck.