Status Bar Message
 

While mousing over a cell with a comment, the status bar shows Cell
[whatever] commneted by [name].

Is it possible to remove all instances of [name] ?

Thanks - Kirk

Status Bar Message
 

Every comment has an Author property.
This is displayed in the status bar on mouse-over.
The property is, sadly, read-only.

This little macro saves your UserName, re-assigns the UserName, re-creates
each comment on the worksheet and then re-establishes your UserName:

Sub ReNameMe()
' gsnuxx
Dim r As Range, cText As String, s As String
s = Application.UserName
Application.UserName = " "
Set rr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeComme nts)
For Each r In rr
With r
cText = .Comment.Text
.ClearComments
.AddComment
.Comment.Text Text:=cText
End With
Next
Application.UserName = s
End Sub


PLEASE NOTE:

1. the macro will not the wording of the comment.
2. special comment formatting may not be preserved.

--
Gary''s Student - gsnu200815 gsnu2007k


"kirkm" wrote:


While mousing over a cell with a comment, the status bar shows Cell
[whatever] commneted by [name].

Is it possible to remove all instances of [name] ?

Thanks - Kirk