Changing Comments Default Position

[Peter Bernadyne]

Hello,

I was wondering if anybody knew how to change the default position o
the comments when the cursor glides over them.

I know that it is easy to 'Show Comment' and grab it by the handler
and drag it around, but I was wondering if there was any way that i
could appear in a different orientation relative to the cell that i
commented instead of the usual 'northeast' orientation it appears t
have by default.

In my version of excel, any changes I make when I show the comment d
not hold for when the cursor glides over it later, after I've hidden i
again.

Thanks,

-Pet

 

[Frank Kabel]

Hi
AFAIK this is not possible. But you may use a macro like
the following to set the comment layout for all inserted
comments:

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

 

[Peter Bernadyne]

Thank you , Mr. Kabel. I hope the day will come when I can return som
assistance. I appreciate all your advice.

I'll give this a go.

Regards,

-Pet