Jock,

All the methods for positioning comments are here and FWIW I think
positioning them centre-screen is excellent and overcomes the problem you
describe.

http://www.contextures.com/xlcomments03.html#Right

Mike

"Jock" wrote:

Hi,
How can I use VBA to show comments above the cell they are attached to
rather than to the right? I have found that as the user moves accross the
spreadsheet, the comments in the right most columns disappear off the screen
until the user scrolls accross. More than a bit annoying!
Thanks,
--
Traa Dy Liooar

Jock