| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save a file with author's name | Excel Discussion (Misc queries) | |||
| Supress rows | Excel Discussion (Misc queries) | |||
| Insert current author's name in cell or footer in Excel?? | Setting up and Configuration of Excel | |||
| #div/0! how do i supress? | Excel Worksheet Functions | |||
| how do i automatically insert the current author's name in a cell. | Excel Worksheet Functions | |||
Linear Mode
