Tags: author, carriage, colon, displayed, excel, microsoft, msdn, return, software, supress, text, workbook

Supress author's name in displayed comment?

On Microsoft » Microsoft Excel

3,401 words with 3 Comments; publish: Fri, 23 May 2008 06:44:00 GMT; (30678.13, « »)

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

All Comments

Leave a comment...

  • 3 Comments
    • 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

      #1; Fri, 23 May 2008 06:45:00 GMT
    • 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

      >.

      >

      #2; Fri, 23 May 2008 06:46:00 GMT
    • 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

      ec35720.excel.todaysummary.com.msn.com

      #3; Fri, 23 May 2008 06:47:00 GMT