Preventing user name from appearing in new cell Comments.

  • Thread starter Thread starter Robert Marsh
  • Start date Start date
R

Robert Marsh

I use the comment feature in Excel 2000 regularly. Every time a new comment
is started, my user name in bold appears. I always have to overwrite it an
turn off bold text before I create the comment.

As I am the only user on this computer, and I do not share the information
on-line with any other users, can some Excel expert please tell me how can I
turn off the automatic insertion of my user name?

Thank you.
 
You can simply go to:

<Tools> <Options> <General> tab,
And in the "UserName" box, replace the name with a space.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I use the comment feature in Excel 2000 regularly. Every time a new comment
is started, my user name in bold appears. I always have to overwrite it an
turn off bold text before I create the comment.

As I am the only user on this computer, and I do not share the information
on-line with any other users, can some Excel expert please tell me how can I
turn off the automatic insertion of my user name?

Thank you.
 
Hi Robert,
Sorry I didn't look at the code in the MS KB article it does not
match preventing like you asked for and it does not even fit
it's own title.

This code will remove the User Name found in
tools, General, username from the beginning of comment cells.

Sub CommentRemoveUserName()
Dim cmt As Comment
Dim LUSR As Long
Dim USR As String
USR = LCase(Application.UserName) & ":" & Chr(10)
LUSR = Len(USR)
For Each cmt In ActiveSheet.Comments
If Left(LCase(cmt.Text), LUSR) = USR Then
cmt.Text Mid(cmt.Text, LUSR + 1)
End If
Next
End Sub

if not familiar with installing using macros see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
You can't turn the feature off. You can substitute another word for your
name, such as "Note". However, the comment will always start with the
contents of the User Name box, and a colon, in bold text.

You can use code to insert a comment formatted as desired, with no name.
There's sample code here:

http://www.contextures.com/xlcomments03.html
 
Back
Top