Comments
 

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

Comments
 

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

Comments
 

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

HTH

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1yw56m_1132650601.5376@excelforu m-nospam.com...

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

Comments
 

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.