Supress author's name in displayed comment?

[John Wirt]

Is it possible to supress the author's name, the colon,
and the carriage return in the comments of a workbook so
that just the text of the comment is displayed in a
mouseover?

I can set all the author's names="" but this does not
supress the colon or the carriage return that follows it.

Thanks.

John

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[John Wirt]

I think one way to accomplish this may be to save all the
comments in a workbook to an array, delete all of the
comments, and then recreate them in code setting only
the .TEXT field of the comment.

This code:

With rngCell
.ClearComments
.AddComment strComment
.Comment.Visible = False
End With

creates comments in a worksheet without an author, the
colon, or the carriage return.

John

 

[Dave Peterson]

Debra Dalgleish has some code at:
http://www.contextures.com/xlcomments03.html#Plain
that may help.