Comments: name includion, font format

[John FM Holstein]

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

[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


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

[Karen]

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

[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


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