Comments

[gumdale_dogs]

Default cell 'comment'.
When attempting to insert a comment the dialogue box initially contains my
name. How do I stop this default entry?

[Bryan Hessey]

The comment is populated with the User Name from Tools, Options, General, User Name, but to remove the name you may need to enter a space in the Options window.

Default cell 'comment'.
When attempting to insert a comment the dialogue box initially contains my
name. How do I stop this default entry?

[Jim May]

Also, check out:
http://groups.google.com/group/micro...116c7e6b72e050

HTH

"Bryan Hessey" <[email protected]>
wrote in message
news:[email protected]...
>
> The comment is populated with the User Name from Tools, Options,
> General, User Name, but to remove the name you may need to enter a
> space in the Options window.
>
>
> gumdale_dogs Wrote:
>> Default cell 'comment'.
>> When attempting to insert a comment the dialogue box initially contains
>> my
>> name. How do I stop this default entry?
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile:
> http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=487117
>

[Héctor Miguel]

hi, gumdale_dogs !

> Default cell 'comment'.
> When attempting to insert a comment the dialogue box initially contains my name.
> How do I stop this default entry?

you may use your 'own' custom AddComment macro ? i.e.
Sub myAddComment()
With ActiveCell
If Not .Comment Is Nothing Then Exit Sub
.AddComment ""
.Comment.Visible = True
ActiveSheet.Shapes(.Comment.Shape.Name).Select
SendKeys " {BS}"
Application.OnTime Now, "HideComment"
End With
End Sub
Private Sub HideComment()
ActiveCell.Comment.Visible = False
End Sub

hth,
hector.