Supress author's name in displayed comment?
 

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

Supress author's name in displayed comment?
 

Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany


John Wirt wrote:
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

Supress author's name in displayed comment?
 

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

-----Original Message-----
Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany


John Wirt wrote:
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
.

Supress author's name in displayed comment?
 

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

John Wirt wrote:

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

-----Original Message-----
Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany


John Wirt wrote:
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
.


--

Dave Peterson