Comments & Scrolling
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.
|