Comments: name includion, font format

[Guest]

In Excel is it possible to set whether to use or not use the user name in
comments? Is it possible to globally change the bold setting to normal
setting? Every time I write a comment--and I write many!--I have to delete
the name and then change from bold to normal.

 

[dominicb]

Good morning John FM Holstein

There is no setting as such that wold help you out here. But on
possible solution would be to use the macro below, either stored i
your personal.xls workbook, or in the files you use or stored as a
add-in. When called this will open an input box for a comment to b
entered which will place a comment without your name in non-bold tex
in the currently active cell.

Sub Comm1()
Dim Comm As String, Comm2 As String
On Error Resume Next
Comm2 = ""
Comm2 = ActiveCell.Comment.Text
Comm = InputBox("Enter your comment:", "Comment Box", Comm2)
ActiveCell.AddComment
ActiveCell.Comment.Text Text:=Comm
End Sub

HTH

Dominic

 

[Debra Dalgleish]

As domincb said, there's no setting you can change. In the comment, if
you start typing where the cursor is, the text should be non-bold. Then,
go back later, and delete the name.

Another macro you can use to insert a comment, that doesn't limit you to
255 characters:

'=======================
Sub CommentAddOrEdit()
'adds new plain text comment or positions
'cursor at end of existing comment text
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment text:=""
End If
SendKeys "%ie~"
End Sub
'==========================

If you need help getting started with macros, David McRitchie has
information:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

How about if I also want to include the "USER NAME", i am not familiar with
macros, can you write it out the whole details for me? Thanks.

 

[Debra Dalgleish]

If you want to include the User name, you could just insert a regular
comment.

But, if you need special formatting, and want to use a macro, David
McRitchie has some information on macros:

http://www.mvps.org/dmcritchie/excel/getstarted.htm