Tags: athttp, author, code, contextures, dalgleish, debra, displayed, excel, htmlplainthat, john, microsoft, msdn, software, supress, wirt, wrotevbcolseagreengt, xlcomments03

Supress author's name in displayed comment?

On Microsoft » Microsoft Excel

771 words with 0 Comments; publish: Fri, 30 May 2008 10:56:00 GMT; (306109.38, « »)

Debra Dalgleish has some code at:

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

that may help.

John Wirt wrote:[vbcol=seagreen]

> 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

> it.

Dave Peterson

ec35720.excel.todaysummary.com.msn.com

All Comments

Leave a comment...

  • 0 Comments