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?
Debra Dalgleish has some code at:
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
> .AddComment strComment
> .Comment.Visible = False
> End With
> creates comments in a worksheet without an author, the
> colon, or the carriage return.
Leave a comment...
- 0 Comments