See code at Debra Dalgleish's site.

http://www.contextures.on.ca/xlcomments03.html#Centre


Gord Dibben MS Excel MVP

On Fri, 11 Sep 2009 18:23:01 -0700, Raymond W. <Raymond
wrote:

I am setting up a workbook and the comments are actually pictures instead of
text. I was wondering if there is some way to set it up so that the pictures
(comments) show up in the middle of the screen (or at least show fully in the
screen) regardless of where the cell is at on screen.

For example, I want the comment to be fully visible on screen whether the
cell is at the extreme high end or low end of the visible worksheet.

Any help is greatly appreciated.