Comments & Rollover

[Guest]

Hello

I have a worksheet with many comments in it. When the comments are shown they appear in the location I need them but when they are hidden and the pointer rollsover the comment they appear in the standard offset location. I have tried various macros to get round this but to no avail.

Anybody got any idea how to alter the default location of a hidden comment when the pointer rollsover

Cheer

Tim Ellis

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlcomments03.html#Reset

 

[Debra Dalgleish]

You can change the position of the visible comments, but not the default
position of the popup comments.