Comments: name includion, font format
 

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.

Comments: name includion, font format
 

Good morning John FM Holstein

There is no setting as such that wold help you out here. But one
possible solution would be to use the macro below, either stored in
your personal.xls workbook, or in the files you use or stored as an
add-in. When called this will open an input box for a comment to be
entered which will place a comment without your name in non-bold text
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

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=482586

Comments: name includion, font format
 

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


John FM Holstein wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Comments: name includion, font format
 

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.
--
Karen


"Debra Dalgleish" wrote:

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


John FM Holstein wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Comments: name includion, font format
 

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


Karen wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html